TimeValue Function

[pkohli88]

Hi,
I have field that includes date and time , If i want to select records for previous 12 hrs. what will be the records selection formula. Using CR 10 version

Thanks

 

[pkohli88]

Hi,
I have got the solution as follows

if currenttime >= time(12,00,00)
then
{TBL_PMNS_SC_PROBLEM.OPEN_DT} >= datetime(currentdate ,currenttime-43200)
else
{TBL_PMNS_SC_PROBLEM.OPEN_DT} >= DateTime (CURRENTDATE-1,CURRENTTIME-43200)

but is there a direct way to subtract 12 hours from datetime function.

Thanks

 

[lbass]

Try:

For your record selection try:

{table.datetime} in dateadd("h",-12,currentdatetime) to currentdatetime

-LB