Date

[mali]

I have a start date in my database when i took a client on board, i want to be able to run a query at any time and want it to calculate how many months the client has been with us, i dont know how to show todays date in a query without typing it in manually, i can easily type in todays date and then run a formula in access to work out how many months they have been with us, but is there any coding that i can put into my SQL query which will display todays date automatically????


Any advice would be great

 

[Mile-O]

Use the Date() function in your SQL as part of the DateDiff() function with the time interval of the DateDiff() function being Months

 

[mali]

thanks i will try that out