Solved

Convert Date time to date field

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Migration from Netsuite to Quickbooks 1 61
Batch convert .doc to .docx 13 312
Problem to file 3 75
Map software access 4 32
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

803 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