if formulas in access

[isladogs]

Hi

Good idea to just use default value Now() for DeallocationTime
I've also set the DeAllocationDate field default as Date()

BTW - you could just combine the 2 fields as DeAllocationDateTime giving output e.g. 17/04/2017 13:35 - to do so set the format as dd/mm/yyyy hh:nn

Database attached - as far as I can see it works
I've modified the 2 fields but otherwise made no structural changes. However the data has been modified so if it was real data you'll need to change it back

 

[murray83]

thanks for the help and input