Hi,
I need to get the previous date (Current date - 1) in stage variable. How to get it. Pls help me.
Sura
How to get the previous date in Transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am
Re: How to get the previous date in Transformer
Can do this way....SURA wrote:Hi,
I need to get the previous date (Current date - 1) in stage variable. How to get it. Pls help me.
Sura
Take two stage variables Stg1 and Stg2.....initialize as 9999-01-01 to both.
If Stg2<>Stg1 Then Stg2 Else Stg1-------->Stg1
and
Input latest date field --------------------------->Stg2
So in Stg1 You can will get the previous date and in Stg2 the latest date...
Regards
Arnie
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: How to get the previous date in Transformer
I found the solutions.SURA wrote:Hi,
I need to get the previous date (Current date - 1) in stage variable. How to get it. Pls help me.
Sura
DateFromJulianDay(JulianDayFromDate(Your_Date)-1).
Thanks for the efforts.
Sura