Calculated Access Field

[hafiff]

Hello:
I need a formula to get a number of days from two fields: today date minus AssignedDate.

I added an unbound field and wrote on control source:
=today() - [AssignedDate]

The above does not work and MS Access does not know what is Today(). Is there any other way to write the code so that I will get the number between today's date to AssignedDate.

I hope that one of the experts can assist me writing this.

Thanks,

 

[Joe4]

In Access, the current date is Date(), not Today()

 

[hafiff]

Thanks!