what is the function to get the currentdate-1

uppalapati2003 · Post by **uppalapati2003** » Tue Nov 27, 2007 5:31 am

Hi all,
is there any function to get the currentdate-1.if not please give me the suggestions to get this value.that was very helpful to me

Thanks,

ray.wurlod · Post by **ray.wurlod** » Tue Nov 27, 2007 5:50 am

DateFromDaysSince() in Transformer stage or date_from_days_since() in Modify stage.

uppalapati2003 · Post by **uppalapati2003** » Tue Nov 27, 2007 6:45 am

Hi Ray,

i had one stagevariable name Stgvar1 it contains the 1999-12-31. i want to get the stagevar1-1 value like 1999-12-30 like this

koolnitz · Post by **koolnitz** » Tue Nov 27, 2007 6:51 am

Hope DateFromDaysSince(-1,Stgvar1) should work in a Transformer!

Define the datatype of your stage variable as DATE

uppalapati2003 · Post by **uppalapati2003** » Tue Nov 27, 2007 7:06 am

Thanks KOOLnitz..its working fine