Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
1 is one day
1/4 is 1/4 of a day, --> 6 hours
1/24 is 1 hour
......