Solved Create Query to add "Month" using the record date file "Order_Date"

[Number11]

Looking to convert a dates
04/01/2023 to "January 23"
01/02/2023 to "February 23"

and so on possible to have both i can get the month only using this

Month: Month([Order_Date]) shows as month number not text

 

[Josef P.]

04/01/2023:
Format(#1/4/2023#, "mmmm yy")

How to convert 04/01/2023 to VBA date?
Try: DateTypeVariable = Cdate("04/01/2023")
.. This will only work with the appropriate country setting.

 

[CJ_London]

use the format function

format(myDate,"mmmm yy")

 

[Number11]

use the format function

format(myDate,"mmmm yy")

Thanks that did the job

 

[CJ_London]

just be aware that the format function creates a string - so will not sort in month order (e.g. April will come before January)

if these date values are fields in a table or query or displayed in a control as a value, there is also the format property which could simply be populated with 'mmmm yy' which will not change the underlying value so sorting will be unaffected.