Data Restriction On Time & Date

[Anonymous]

Hi,

I have a scenario where data consists of Date & Time. Now If User wants to see report then it should show values from Yesterday 6.00AM to Today 6.00 AM.Please look into it.

Thanks in Advance

[jagan]

Hi,

Today() gives you 2/17/2015 12:00:00

1/4 = 6/24 = 6 AM (6 AM/24 Hrs)

We are adding Today() + 1/4  which gives 2/17/2015 06:00:00

3/4 = 18/24 = 6 PM (18/24 Hrs)

We are adding Today() + 3/4  which gives 2/17/2015 18:00:00 OR 06:00:00 PM

Hope this helps you.

Regards,

Jagan.

[maxgro]

1 is one day

1/4 is 1/4 of a day, --> 6 hours

1/24 is 1 hour

......