Calculate 30 minutes earlier

[Tim]

Can you show me how to calculate a short time, i.e., 13:35, so that the
result is 30 minute earlier; so it should show 13:05? Another example is:
13:05, the field on the report will show 12:35. Thanks!

 

[KARL DEWEY]

Adjusted Time: DateAdd("n", -30, [YourDateField])

 

[Tim]

Perfect!

Thank you!

Adjusted Time: DateAdd("n", -30, [YourDateField])

--
Build a little, test a little.

Can you show me how to calculate a short time, i.e., 13:35, so that the
result is 30 minute earlier; so it should show 13:05? Another example is:
13:05, the field on the report will show 12:35. Thanks!