Dates & Parameter Values

[honey2wood]

Hello to All.

I have two problems which combine to make 1 big problem.

1. I am importing data from an Excel spreadsheet. One of the fields is a date field. But not just a date but a time as well. 30/04/2010 13:33:47. I dont need the time part.
In my database I have a query which asks for a date using 'Enter Parameter Values' box. This will not work unless I include the time as well as a date.

2. If with help I manage to just have to enter a date can I use 30/04/10 instead of 30/04/2010 in the parameter values. This causes problems for other users that are not used to using the full date format.

I hope this all makes sense. I expect it will be something to do with formating but I dont seem to be able to find out anything about it.

Thanks for looking at this and for any help you can give.

Graham

 

[Brianwarnock]

Compare your criteria against a field using the Format([yourdatefield],"mm/dd/yyyy") and yes it will accept 2 digit years.

Brian

 

[honey2wood]

Thanks for that Brian

I see how it is done now.

Kind Regards
Graham