OpenReport filter only working with American date format

[Mark Wild]

I have a report that picks up a date from a textbox and uses this date as its filter. However, it will only bring through the data is I turn the date into the American format of mm/dd/yy

Everything in the system to the best of my knowledge is in the UK style of date.

Can anyone advise on why I'm getting this problem and if there is a work around. I've added the line as it should be at how I can get it to work

DoCmd.OpenReport "RptLoanActivity", acViewPreview, , "((MaturityDate) = #04/18/04#)"

'"((MaturityDate) = #" & me.tbMaturityDate & "#)"

Thanks

 

[Rich]

Use the Format function, examples have been posted here

 

[Mark Wild]

Cheers. Such a simple solution...