How to add minutes with current time in table

[nayan]

I want to add time with current time. It will be based on Minutes field. Result will be in Expire field.

=DateAdd("n",20,Time())

is working fine. But

=DateAdd("n",[Minutes],Time())

make an error.

[orange]

Instead of separately recording Data and Time, investigate the intrinsic Now function in Access.

Good luck and welcome to the forum.

[nayan]

Actually i am new in access. Could you plz give me some true step to solve this problem? I just want to store calculated time in Expire field.

[orange]

Best practices would suggest you do NOT store calculated values. You use a query to determine Expire whenever needed.

If you use the Now function, as suggested, that will give Date and Time in a single field. You can then use your DateAdd function to determine/calculate Expire.

[CJ_London]

@Nayan

for your education, time is actually stored as a decimal number (now is 43717.6309953704), the bit before the decimal point represents the number of days since 31/12/1899 and the bit after, the time expressed as the time in seconds since midnight divided by the number of seconds in the day (86400).

Suggest you google 'time datatype' to find out more.

edit: taken out alternative calc as irrelevant

[Uncle Gizmo]

You might find that this video provides some inspiration or possibly perspiration!

https://youtu.be/D_magBM3rOY

Sent from my Pixel 3a using Tapatalk