How to minus one day from a give timestamp data

[prams]

Hi All,
i have a requirement like

i need to subtract one day from given time stamp

how to do in trnsformer, can any one help me in this regard

Thanks & Regards
Prams

[chulett]

Investigate the use of the DaysFromDateSince function, both by searching here and by reading the documentation.

[ray.wurlod]

Probably DateFromDaysSince() would be more appropriate.

[chulett]

Whoops, that was what I meant but not what came out of my fingers.

Damn fingers.

[prams]

Thanks for the input,

by using DateFromDaysSince()
i am able to get the date which is required but i need the time stamp also,

is there any option to to get timestamp also

input is timestamp and out put is also timestamp.

but now i am getting like
input is timestamp and output is date format.

thanks for the valueable input

Thanks & Regards
Prams

[chulett]

Data format? Does the timestamp need to be converted? If not, simply cat it back on the end of the converted date.

[ray.wurlod]

You will need to decompose your input timestamp into date and time components, adjust the date component, then reassemble. You do not have to convert to string (which is what Craig suggests) - there are functions such as TimestampToDate() that you can use.

[prams]

Thank you chulett and ray.wurlod for your valueable input.

its working

Thanks & Regards
Prams

[fmcmullan]

I have used TimestampFromSecondsSince(-86400, X) to do this without having to deconstruct/reconstruct anything. It has worked well for me.

[ray.wurlod]

Beware that 2008-12-31 has 86401 seconds!