Post reply

Getting last day of a month from a given date !

  • June 23, 2010 at 12:42 am

    #1183737

    Hi,

    your problems aris from the diff with the 0 date. If you use this, dateadd(month) will always add 30 days...

    it seems that this one

    DATEADD("day",-1,DATEADD("month",1,((DT_DBDATE)(DateStrimg + "/01"))))

    would do the job...

    WM_JUSTMY2CENTS

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply