Changeing Date Formats

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,



CDate( "1 " & MonthYearValue )



the concatenation would make "1 January 2003", CDate should be able to
understand this is the first of January, 2003, with most regional settings
understanding English month name.


Hoping it may help,
Vanderghast, Access MVP.
 

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

Excel Vba to change displayed year automatically. 14
Year Beginning Date 2
date format lost in UNION query 4
Date query 2
Help with generating week dates for a table. 2
converting numeric date to text date 2
Changing date fotmats & calculating date - HELP 5
Date format 1

Back
Top