YYYYMMDD question

  • Thread starter Thread starter bluefalcon904 via AccessMonster.com
  • Start date Start date
B

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.
 
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...

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..
Click to expand...
[quoted text clipped - 5 lines]
thank you.
Click to expand...
Click to expand...
 
Try using the following for your criteria:

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