Page 1 of 1
Timestamp - 1
Posted: Tue Aug 26, 2008 12:28 pm
by wgdsd
Hi,
Can I use some function to get previous timestamp?
e.g: - Input: - 2008-08-26 00:00:00
Output: - 2008-08-25 00:00:00
Posted: Tue Aug 26, 2008 1:11 pm
by chulett
DateFromDaysSince() I would think.
Posted: Tue Aug 26, 2008 3:27 pm
by wgdsd
DateFromDaysSince() is working only when the target datatatype is 'Date'. My target field is 'TimeStamp'
Posted: Tue Aug 26, 2008 3:32 pm
by chulett
Right, we know. Was hoping you would figure out the need to separate the two portions before performing the calculation. And when you are done, put the time back on.
Posted: Wed Aug 27, 2008 9:16 am
by wgdsd
Alright. Thanks For your help.
Posted: Wed Aug 27, 2008 10:14 am
by mddw08
Or you can use TimestampFromSecondsSince(-86400,input.timestamp)
Posted: Wed Aug 27, 2008 10:15 am
by chulett
Good to know!
