This expression should do it if your Date field is already a timestamp. The formatting of the time doesn't matter.
if(Status='not delivered' and Now()-Date>2, red(),white())
But if your Date field is a string you need to make a timestamp of it first:
for a 24 hour format: timestamp#(Date,'YYYY-MM-DD hh:mm:ss')
for an am/pm format: timestamp#(Date,'YYYY-MM-DD hh:mm:ss tt')
I've used the now() function which includes the time. If you want the start of today instead use the today() function.
Now()-Date>2 means the difference between now() and Date is larger than 2 days, i.e. 48 hours.
I tried in different ways . But it is not giving what i require . More over Now()-Date nor TOday()-Date is not giving the correct output. my data looks like this
Ticket No. Date Opened i-2166541 01-11-12 07:00 i-2166707 01-11-12 09:11 r-2167098 01-11-12 13:05 i-2167177 01-11-12 13:53 i-2167377 01-11-12 17:23 i-2167758 02-11-12 06:39 i-2168539 02-11-12 17:24 i-2169064 05-11-12 02:44 i-2169081 05-11-12 03:15
Can you please create a small application with this data and can you give me what i require
and correct me where i am going wrong.
In the application please use both NOW and Today functions for clear understanding how they work