Ok I think I have this now I changed it to this for the set field action $DATE$ + 61200 and this will set the field to 5 PM regardless of when the escalation is run if I am correct.
But thank for reading this if I am correct. Dan ------------------------------------------------------------------------ --------------------------- Good Monday morning everyone :-) I have an escalation that runs at 1AM and what I want it to do is set a field to 5 PM for the current day. 4/DATE/2007 5:00:00 PM right now I was doing $TIMESTAMP$ + (60 * (60 * 16)) but if the escalation is delayed at all it will push the timestamp past 5 PM. So is there better way of doing this I bet there is any help would be great. 6.3 Windows SQL Dan Caissie _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
