Date Calculation

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

Date Calculation

Postby 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.
gsubrama
 
Posts: 1
Joined: Thu Nov 21, 2013 12:49 pm

Re: Date Calculation

Postby 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/post418.html?hilit=SQL%20Help&sid=0812b30393d773d8999718895cb5d541&sid=0812b30393d773d8999718895cb5d541#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
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support_Rick
Support Specialist
 
Posts: 200
Joined: Tue Jul 17, 2012 2:12 pm


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron