Solved

Convert Date time to date field

Posted on 2014-02-20
1
377 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 29

Accepted Solution

by:
Randy Downs earned 500 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Replace Adobe Acrobat XI with what? 2 92
Open Source: Multi-Level-Marketing software? 3 132
Web Browsers Start Page Hijacker 14 111
Win 7 OS unable to install Win updates 3 139
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
Viewers will learn how to use the Hootsuite Dashboard.

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now