Date Calculation

[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.

[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...