If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculate 30 minutes earlier
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! |
#2
|
|||
|
|||
Calculate 30 minutes earlier
Adjusted Time: DateAdd("n", -30, [YourDateField])
-- Build a little, test a little. "Tim" wrote: 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! |
#3
|
|||
|
|||
Calculate 30 minutes earlier
Perfect!
Thank you! "KARL DEWEY" wrote: Adjusted Time: DateAdd("n", -30, [YourDateField]) -- Build a little, test a little. "Tim" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|