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
Datae cannot be in future, If future rejects
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
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
Since you using a two digit notation for year, also take care of the century break year which would decide your actual year
- Zulfi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
StringToDate(InLink.TheDate, "%mm/%dd/%yy") > CurrentDate()
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.