We help IT Professionals succeed at work.

Default Date Type - Access 2003 Date Field linked to Crystal Reports 10

Medium Priority
196 Views
Last Modified: 2012-05-06
I have several date fields in my table that I will be reporting from and I need one of them to be a "Date" field instead of "DateTime".  However, it seems that Crystal defaults all date fields from access to the DateTime format.  I would like it in the Date format so that I can use it in a parameter and not have the user worry about entering a time value of 12:00:00 AM as well.

Thanks.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
You don't have any choice.  CR will always treat Access datetime fields as datetime.  Access doesn't have any other type of date field.  You're stuck with it as it is.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I was afraid of that.  Thank you for the prompt reply.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
You can do it this way

Date({YourField}) = {?DateParameter}

mlmcc
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
You could also create a formula to do the conversioin
Formula - DateOnly
Date({YourField})

mlmcc
CERTIFIED EXPERT

Commented:
Yes that's true.

Maybe I read more into the Q than was there.
I assumed the user wanted to pick a date from a list of database values.
If they are just entering a date then there is a solution.

Michael- you can sort out the re-opening etc can't you?
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
No need.  I just added another idea.

mlmcc
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.