Page 1 of 1
Datae cannot be in future, If future rejects
Posted: Tue Jun 12, 2012 10:17 pm
by e1994264
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
Posted: Tue Jun 12, 2012 11:52 pm
by zulfi123786
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
Posted: Wed Jun 13, 2012 12:54 am
by ray.wurlod
Code: Select all
StringToDate(InLink.TheDate, "%mm/%dd/%yy") > CurrentDate()