subtract 1 day from timestamp

[agni_gold]

hi,

11/12/2011 12:00:00 AM

is time i want result like

11/11/2011 12:00:00 AM

[its_anandrjs]

Hi,

Use add months

Hope this helps

Thanks & Regards

[its_anandrjs]

Hi,

Use like =AddMonths(Datefield,-1)

Hope this helps

Thanks & Regards

[agni_gold]

My format is MM/DD/YY

and i want to subtract 1 day from date only .

[maxgro · Accepted solution]

=date(date#('11/12/2011 12:00:00 AM', 'MM/DD/YYYY hh:mm:ss TT') - 1, 'MM/DD/YYYY hh:mm:ss TT')

[its_anandrjs]

Hi,

Do like this

Temp;

LOAD Date(Datem,'MM/DD/YYYY HH:MM:SS TT') AS Datem;

LOAD * Inline

[

Datem

11/12/2011 12:00:00 AM

];

And then in front end do this in any chart

=Date(Datem-1,'MM/DD/YYYY')

Hope this helps

Thanks & Regards