I am trying to create a group based on the modify date of a ticket. We would like to view tickets that have not been modified within the last 12 hours. Any way to specify a variable instead of an actual date? Right now i have the ticket.modifydate set to within the last 1 day. i would like it to be 12 hrs. i tried 0.5 but got an error.

Thanks

jb 

This is possible. But certainly not by me.

I have asked one of my programmers and this is the response I received.

First, this is for a Sql based SalesLogix.

In your conditions you would use the modifydate field, operator would be "Less than".

In the value......make sure you check the box....."use a literal"

then.....

DATEADD ( hour , -12, getutcdate() ) or DATEADD ( hour , -12, getdate() )

It is either the getucdate or the getdate.

If you need further assistance on this specific topic.... you might try slxdeveloper.com.

 

Good Luck,

 

Dale

Hey it looks like it worked. Thanks for your quick and accurate response. My users thank you as well. have a great day.