Using current date in queries

[Ernest Lai]

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

 

[Allen Browne]

Try this in the Field row of your query:
Expr10: Format(Date(), "yyyymmdd")

 

[Ernest Lai]

Hehe thanks allen, I just found it in the help files as well. V fast reply