Query criteria: reformat date from Calendar Control to yyyy/mm/dd

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

Guest

Using MSCAL.calendar.7 as calendar control in form. Need to use date
selection output as criteria in query... need to reformat date in critieria
to yyyy/mm/dd format to match date format in table field. Need help with
writing criteria expression to accomplish.

Thank you much for help!!
 

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

ccyymmdd to dd/mm/yyyy from query 2
Format Date "dd/mm/yyyy" 1
convert date format from mm/dd/yyyy to dd/mm/yyyy 3
Formatting date gives bad results in query 2
Date Function in query 3
create input mask "yyyy-mm-dd" 5
Date() update format 5
reformat dates to yyyy/mm/dd 5

Back
Top