Hi
I want to load last month data(September) in this month(october), so i want the month end date to be of last month(September), not of this month_end.
this code works for this month OConv(MONTH.LAST(MONTH.TAG(DATE())),'D-YMD[4,2,2]')
what code can i use to get the last month_end date in this month, i'm using datastage 7.5.1
month_end date
Moderators: chulett, rschirm, roy
month_end date
-------------------------
https://www.ssa.co.za
https://www.ssa.co.za
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Code: Select all
OConv((MONTH.FIRST(MONTH.TAG(DATE())) - 1) ,'D-YMD[4,2,2]')
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>