• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

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

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.
0
Longship-PC
Asked:
Longship-PC
  • 3
  • 2
1 Solution
 
peter57rCommented:
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.
0
 
Longship-PCAuthor Commented:
I was afraid of that.  Thank you for the prompt reply.
0
 
mlmccCommented:
You can do it this way

Date({YourField}) = {?DateParameter}

mlmcc
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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

mlmcc
0
 
peter57rCommented:
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?
0
 
mlmccCommented:
No need.  I just added another idea.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now