Default Date format for Parameter Fields (1 Viewer)

dogman01

Registered User.
Local time
Today, 07:25
Joined
Dec 3, 2008
Messages
47
Is there anyway to change the format for a paramater date field from yyyy-mm-dd to mm-dd-yyyy? Sure seems like this option should be able to be changed. Not really a normal format for users.
 

Brianwarnock

Retired
Local time
Today, 11:25
Joined
Jun 2, 2003
Messages
12,701
When I have used parameter prompts I have not been forced into that format, however to answer your question there is a Parameter clause in queries, it is the first, however it is easier to use in the design grid
Select query then Parameters from the menu and drop down and away you go.

Brian
 

SOS

Registered Lunatic
Local time
Today, 04:25
Joined
Aug 27, 2008
Messages
3,517
When I have used parameter prompts I have not been forced into that format,
Are you talking about Crystal Reports (as this is a CR question)? I've had it where the date requirement was to enter it that way. Not sure if it has to do with the dates in the underlying recordsource or something, but I have seen that in Crystal.
 

Brianwarnock

Retired
Local time
Today, 11:25
Joined
Jun 2, 2003
Messages
12,701
Oops! I'll just sneak away to a dark corner somewhere. :eek:

Brian
 

Users who are viewing this thread

Top Bottom