how to get 30 days old date from current date

[Cherukuri]

Hi,

Please help how to get 30 days old date from current date .

Thanks and Regards,

[bob7027]

do you need exact 30 days old date or every last month date..?

[Cherukuri]

Thank you for the reply...

I want 30 days old date..

for example today is : 26-04-2013

output should be : 27-03-2013 (which is 30days old date)

Please help on this.

[chulett]

Look into the DateFromDaysSince() function, or if you are on 8.5+ there's DateOffsetByComponents() as well. Always a good idea to check the documentation first when you have a question like this. While there you'll also find functions like CurrentDate() or CurrentTimestamp() depending on what you need.

[chandra.shekhar@tcs.com]

As suggested by Craig,
for Datastage 8.5+

Code: Select all

DateOffsetByComponents(CurrentDate(),0,0,-30)

For Earlier versions of Datastage

Code: Select all

DateFromDaysSince(-30, CurrentDate())

[Cherukuri]

Thank you for your help and time.