month_end date

BIuser · Post by **BIuser** » Thu Oct 04, 2007 2:53 am

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

bkumar103 · Post by **bkumar103** » Thu Oct 04, 2007 3:03 am

If you are loading the data to database. Then you can use the database functions to get the last date of the month. which database you using.

JoshGeorge · Post by **JoshGeorge** » Thu Oct 04, 2007 3:40 am

Code: Select all

OConv((MONTH.FIRST(MONTH.TAG(DATE())) - 1) ,'D-YMD[4,2,2]')