Page 1 of 1

Date Calculation

Posted: Thu Nov 21, 2013 1:22 pm
by gsubrama
Is there a way to calculate new date based on an certain text from file name and adding numeric value to it?

i.e. file name is CM-29082013T060000-30082013T055959-001.xml. I want to verify if the first date in the file 29082013 + 1 day is equal to the second date in the file 30082013.

Is there a way to achieve this in GoAnywhere Director? The date calculations options seems to be very limited and mostly based on the current date. Any previous experience on this matter would be appreciated.

Re: Date Calculation

Posted: Thu Nov 21, 2013 10:06 pm
by Support_Rick
Guru,

Review this link about retrieving the last digit of the year:

http://www.goanywheremft.com/forum/post ... 5d541#p418

I had created a Utility for these type situations a year or so ago. It allows you to utilize any SQL functions to return a value. With that being said, you could use this SQL Help utility and return the "Date + 1" value after parsing out your dates.

Read through it and if you have any questions, let me know...