I have a timestamp field result_time
RESULT_TIME
2008/03/01 05:57:00

and I used HADD to add 24 hours to it.
COMPUTE RS24_TIME/HYYMDS = (RESULT_TIME,'MINUTE',1440,8,'HYYMDS');

RS24_TIME
2008/03/02 05:57:00

Can anyone help me calculate a new field that subtracts 24 hours from RS24_TIME?

BAS24_TIME
????/??/?? ??:??:??

Any ideas?

Thanks!

This message has been edited. Last edited by: Kerry,

Using -1440 comes to mind.

quote:

Using -1440 comes to mind.

ROFL

Sorry Tom, you must have been having one of those days! Mid week - not Monday and not Friday, just one of those inbetween days where nothing goes right. I've have them last from Tuesday to Thursday

T