YYYYMMDD question

[bluefalcon904 via AccessMonster.com]

Hi..

I have a table with a date field in mm-dd-yyyy format. How do I make a query
that when I enter date in YYYYMMDD format would search in the date field even
though its in mm-dd-yyyy format.

Appreciate the help.

thank you.

 

[Klatuu]

You will need to convert the entry to a date format. If you are entering the
YYYYMMDD in text box on a form and calling the query from the form using the
value of the text box as a date criteria:

DateSerial(Left([forms!MyForm!MyDate, 4), Mid([forms!MyForm!MyDate, 5,2),
Right([forms!MyForm!MyDate, 2))

 

[bluefalcon904 via AccessMonster.com]

Hi...

How can I do it in Select format? sorry.. im just a newbie.
thanks

You will need to convert the entry to a date format. If you are entering the
YYYYMMDD in text box on a form and calling the query from the form using the
value of the text box as a date criteria:

DateSerial(Left([forms!MyForm!MyDate, 4), Mid([forms!MyForm!MyDate, 5,2),
Right([forms!MyForm!MyDate, 2))

Hi..

[quoted text clipped - 5 lines]

thank you.

 

[Douglas J. Steele]

Try using the following for your criteria:

=CDate(Format([When?],"0000\-00\-00"))

 

[bluefalcon904 via AccessMonster.com]

Hi Douglas... IT WORKED!!! Thank you so much!

Try using the following for your criteria:

=CDate(Format([When?],"0000\-00\-00"))

Hi..

[quoted text clipped - 7 lines]

thank you.