date conversion

[Former Member]

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}))

[former_member205840 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Sastry,

I have only year.Thank you it is working