Between Dates

[mithani]

Hi friends,

The following is not showing the exact dates in report.

DoCmd.OpenReport "Purchase Report", acViewPreview, , "([InvoiceDate] Between #" & Me.OSTARTDATE & "# And #" & Me.OENDDATE & "#)"

Any help?

thanks

Mithani

 

[WayneRyan]

Mithani,

Not much info to go on.

Are your form dates short dates?

Do your InvoiceDate fields have a time component.

If so; 8/9/2007 02:45:00 PM is not between 8/1/2007 and 8/9/2007.

need more info,
Wayne

 

[mithani]

Sorry Wayne,

Yes are short dates but no time. I think date format seems a problem. How can I set British date format (dd/mm/yyyy)

thanks

mithani

 

[WayneRyan]

Mithani,

Oops, I don't work with British Dates, but there have been a LOT of posts:

http://www.access-programmers.co.uk/forums/search.php?searchid=1444401

Wayne

 

[mithani]

Thanks Wayne

 

[WayneRyan]

Mithani,

Glad to point you in the right direction.

See ya,
Wayne