Fetching past date and time

Hi Vinitha,

Try this once

now()- intervalds(1,0,0)

This funtion subtracts 1 hour from current time

Hope this helps

Hi,
you can use below :

time(hour(now())-1,minute(now()),second(now()))

Regards
Abhay

Hi , are you trying to fetch it from Db?

Hi  ,

You can try the below approach as well.

datetime( year(now()),month(now()),day(now()),hour(now()),minute(now())-60) or

datetime( year(now()),month(now()),day(now()),hour(now())-1,minute(now()))

You can use this logic for past year, month,day as well.

date( year(now())-1,month(now()),day(now()))

You can use intervalds, which returns you duration and then you can deduct that duration from now().
Example: now()-intervalds(1,0,0)

Or you can do it in a crude way i.e. by finding the decimal value of 1 hour in a day.
1 hour in Day is 0.0416667.
So if you substract 0.0416667 you will get 1 hour less than the current time.

Example : now() - 0.0416667

Please let me know if it helped.