Date conversation

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

srini.dw
Premium Member
Premium Member
Posts: 186
Joined: Fri Aug 18, 2006 1:59 am
Location: Chennai

Post by srini.dw »

StringToDate((YearFromDate(CurrentDate())-1):"-12-01", "%yyyy-%mm-%dd")

The above 1 works for me, Thanks for all
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

If you are all set, you can mark the topic as resolved.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

O yea. I , also forgot to mention, you dont need to change integer to string in order to concatenate it. The DecimalToString() was the culprit. Get rid of it and you will be fine. If you noticed, I did the same for the second piece.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply