Date format (last day of previous month)

[srini.dw]

Iam using DataStage 7.5 PX version, I have date coming as 2007-03-02, 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.

[DSguru2B]

Care to share the workaround?

[dsdev750]

Since you want to do it in one line,

DateFromDaysSince(-1, StringToDate(DateToString(DSLink2.col1, "%yyyy-%mm-%dd")[1,8] : '01', "%yyyy-%mm-%dd"))

[ray.wurlod]

Or, slightly simpler:

Code: Select all

DateFromDaysSince(-1, StringToDate(DateToString(DSLink2.col1, "%yyyy-%mm") : '-01', "%yyyy-%mm-%dd")) 

[srini.dw]

Its working, thank you