Access 2003 - Date Query

[philb99]

Hi - I have been using on a Query for a while where the date(in text) is 23/03/2012. Unfortunately a process has changed the date (in text) to 23/Jun/2018.

Therefore when I use my Query Like "*06/2018" it brings nothing back I have tried all kinds of variations (trying to return all entries from 1-30 June

Can anyone help please

 

[sheetspread]

Can you replace Jun with 6 using ctrl-h?

 

[philb99]

Sorry meant to advise that I have 1m rows of data with variable dates.

 

[welshgasman]

Use the format function to get the correct format? Then use MonthName in abbreviated mode. Format below is for abbreviated

format([field],"dd/mmm/yyyy")

Hi - I have been using on a Query for a while where the date(in text) is 23/03/2012. Unfortunately a process has changed the date (in text) to 23/Jun/2018.

Therefore when I use my Query Like "*06/2018" it brings nothing back I have tried all kinds of variations (trying to return all entries from 1-30 June

Can anyone help please