Datae cannot be in future, If future rejects

e1994264 · Post by **e1994264** » Tue Jun 12, 2012 10:17 pm

I am getting date from my source file as MM/DD/YY. How do i check the Date value.
Transformation rule:
Datae cannot be in future, If future rejects . If blank set to default value

zulfi123786 · Post by **zulfi123786** » Tue Jun 12, 2012 11:52 pm

the term "future" has to be clarified here. is this a one time stuff or supposed to run in production on a daily basis, if so then is "future" something that is greater than the run date ?

Since you using a two digit notation for year, also take care of the century break year which would decide your actual year

ray.wurlod · Post by **ray.wurlod** » Wed Jun 13, 2012 12:54 am

Code: Select all

StringToDate(InLink.TheDate, "%mm/%dd/%yy") > CurrentDate()