Timestamp - 1

wgdsd · Post by **wgdsd** » Tue Aug 26, 2008 12:28 pm

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

chulett · Post by **chulett** » Tue Aug 26, 2008 1:11 pm

DateFromDaysSince() I would think.

wgdsd · Post by **wgdsd** » Tue Aug 26, 2008 3:27 pm

DateFromDaysSince() is working only when the target datatatype is 'Date'. My target field is 'TimeStamp'

chulett · Post by **chulett** » Tue Aug 26, 2008 3:32 pm

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.

wgdsd · Post by **wgdsd** » Wed Aug 27, 2008 9:16 am

Alright. Thanks For your help.

mddw08 · Post by **mddw08** » Wed Aug 27, 2008 10:14 am

Or you can use TimestampFromSecondsSince(-86400,input.timestamp)

chulett · Post by **chulett** » Wed Aug 27, 2008 10:15 am

Good to know!