Skip to Content
avatar image
Former Member

date conversion

Hi All,

Sorry for asking basic question.

I have string field called year .And I am trying  to add 1 more year to that.But I am getting error like bad date format.

Please suggest

dateadd(''yyyy'',1,date({OBJSETTING_MASTER_DATA.YEAR}))

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 08, 2014 at 08:41 AM

    Hi

    If this field consist of only year then you can do the following :

    Tonumber(({OBJSETTING_MASTER_DATA.YEAR}) +1

    or

    If you have date then

    date(Year(cdate(({OBJSETTING_MASTER_DATA.YEAR}))+1, Month({OBJSETTING_MASTER_DATA.YEAR}), Day({OBJSETTING_MASTER_DATA.YEAR}))

    -Sastry

    Add comment
    10|10000 characters needed characters exceeded