Date Calculation

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts Page 1 of 1

gsubrama

Posts: 1
Joined: Thu Nov 21, 2013 12:49 pm

Post by gsubrama » Thu Nov 21, 2013 1:22 pm
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

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Thu Nov 21, 2013 10:06 pm
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...
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1