brettanderson77
asked on
Returning System Date in MS Access SQL
Hi,
Could not believe I couldn't find this on the web so sorry to ask. I just need to return the system date (so date at the time of running the query) as a value in a field. Can not for the life of me remember how to do this.
Thanks for your help.
Cheers,
Brett
Could not believe I couldn't find this on the web so sorry to ask. I just need to return the system date (so date at the time of running the query) as a value in a field. Can not for the life of me remember how to do this.
Thanks for your help.
Cheers,
Brett
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use Date() for just the date, Now() for the date and time.
ASKER