[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Convert Date time to date field

Posted on 2014-02-20
1
Medium Priority
?
409 Views
Last Modified: 2014-02-21
I have a report with fields in the database that are date time fields. I cant convert them to just date fields in the database but can I convert them to date fields in crystal reports, This will enable the information for the whole day to be included.
0
Comment
Question by:Stevepaget
1 Comment
 
LVL 30

Accepted Solution

by:
Randy Downs earned 2000 total points
ID: 39876075
Try this


In crystal report formulafield date function available there pass your date-time format in that You Will get the Date only here
 Example: Date({MyTable.dte_QDate})

Open in new window

0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you are like me and like multiple layers of protection, read on!
Web hosting control panels were first developed to make it faster and easier for most users to set up and operate websites. The graphical user interface (GUI) allows users to perform tasks by pointing and clicking rather than typing highly specific…
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question