Hi All,
Can someone please suggest me how do solve this in datastage,
I have a create_date, start date and end date. End date is nullable. create date and start date are not nullable.
all 3 date columns are in the format mm/dd/yyyy (eg:7/24/2009)
if create_date is >= start_date and create_date <= end_date (if end date exists) then output data.
The create date and start date have to compared to the granular level i.e. month, date and year.
eg: create date can be 8/10/2011 and start date can be 8/9/2011. in this cate create date is greater than start date.
Thanks
Pavan
Date Comparision
Moderators: chulett, rschirm, roy
The easiest way to work at this problem is to convert all 3 strings to dates - StringToDate(In.col,"%mm/%dd/%yyyy") and then you can do the ">" and "<" comparisons.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>