MS Access MMYY format 1

[rugbyguy]

Help please,

I am trying to query a database (access 2003). The date that is stored in my database is in MMYY format (I know - not too swift of me for digging my own hole!)

I have created a query parametre that asks for 'beginning date' and 'end date'. The problem is that Access does not recognize this format as a date. There is also the question of system settings for date. How can I query 1102 ('start date') and 0204 ('end date')? How can I define the first 2 digits as month and the last 2 digits as year?

Any and all help appreciated.

Thanks

 

[KenReay]

Hi

"I have created a query parametre that asks for 'beginning date' and 'end date'. " suggest it is a date, but if it is not then:

WHERE Mid(MMYY,3,2) & Left(MMYY,2) Between Mid(Forms!MyForm!Fromdate,3,2) & Left(Forms!MyForm!Fromdate,2) AND Mid(Forms!myForm!ToDate,3,2) & Left(Forms!MyForm!Todate,2)

cannot believe it got to almost 30 posts to sort that out


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[rugbyguy]

Thanks for all the posts - I will never "repeat never" underestimnate the power of the inverted date!

many thanks to all! -