How to add one day to a Timestamp in PX

mattu · Post by **mattu** » Thu Jan 11, 2007 12:54 am

Hi Friends,
I want to add/substract one day from a giveg Timestamp in PX. Can you please give some solution/suggestions how to achive this?

Thanks in Advance.

Regards,
Mattu

ray.wurlod · Post by **ray.wurlod** » Thu Jan 11, 2007 1:30 am

Extract the date, convert to Julian, add 1, convert back to date and re-assemble the timestamp.

arnabdey · Post by **arnabdey** » Thu Jan 11, 2007 1:54 am

You can use this

StringToTimestamp(DateFromJulianDay((JulianDayFromDate(Left(DSLink3.timstm, 10))+1)):Right(DSLink3.timstm,9))

where DSLink3.timstm is the input timestamp.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 11, 2007 6:12 am

Only if the source timestamp is a string. What if it's really a timestamp? The OP was unclear on this point, which is why my solution was couched in general terms.

arnabdey · Post by **arnabdey** » Thu Jan 11, 2007 8:27 am

Hi Ray

I had tried this in a job and then posted. It's input format is timestamp only, in the form yyyy-mm-dd hh:mm:ss. Now this format can be set at project level as well as job level.

Thanx

DSXchange

How to add one day to a Timestamp in PX

How to add one day to a Timestamp in PX

Using Julian date