Using current date in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I would like to produce a query where the current date is shown but not in
the default way. I searched the help file and you can use this: Expr10:
Date()

However this displays the date in the format: MM/DD/YYYY
I would like todays date to be show in the following format:

YYYYMMDD with no seperators.


Any help much appreciated and many thanks in advance

Ernest
 
Try this in the Field row of your query:
Expr10: Format(Date(), "yyyymmdd")
 
Hehe thanks allen, I just found it in the help files as well. V fast reply :D
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to date format? 0
Date search query 0
Stored date is not being recognised 1
printing report with date 3
Date Formatting 1
Excel date format YYYYMMDD 1
Date format when exporting 2
Formating dates and ordering in queries 4

Back
Top