Question

Datetime with current date

Hi,

I need to modify time stamp given by caladddays to 12:00AM always. How do I do that.

Thanks

Hi [mention:9db259808ae24c388bcfc9ab2f9a484c:e9ed411860ed4f2ba0265705b8793d05],

I have come up with two possible ways to do it, you can use whichever you like

1.

todatetime(todate(caladddays(now(),2)))

2.

subtracthours(caladddays(todate(now()),3),12)

Sign up