Date format (last day of previous month)

srini.dw · Post by **srini.dw** » Tue Feb 20, 2007 9:34 am

Iam using DataStage 7.5 PX version, I have date coming as 200703, i need to convert to 2007-02-28 i.e., last day of the previous month, whenever i run the job, can we do it in a single line i.,e i.,e Transformer.

Srini

srini.dw · Post by **srini.dw** » Tue Feb 20, 2007 10:02 am

DateFromDaysSince(-1, StringToDate(RUN_DT, "%yyyy%mm") : "%yyyy-%mm-%dd")

got the solution
thanks

narasimha · Post by **narasimha** » Tue Feb 20, 2007 10:49 am

Thanks for sharing the solution.
Time to mark the post as Resolved!