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

Converting date/time to date format

I have a field which is set to date/time
I want to convert it to date only
what formulae do i use

Gordon
0
Gordon Hughes
Asked:
Gordon Hughes
  • 3
  • 3
1 Solution
 
vguzmanIT ManagerCommented:
right click on the field, choose 'date and time' field, then select a date format you like
0
 
Gordon HughesDirectorAuthor Commented:
Hi
I know about the formating etc
I would like to create a formulae something like:

ToDate ({WO.REQUESTDATE})

The current field {WO.REQUESTDATE} is set to date/time and I want it set to Date

Gordon
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Gordon HughesDirectorAuthor Commented:
Found it
CDate ({WO.REQUESTDATE})
0
 
vguzmanIT ManagerCommented:
if your datatime is a formula then use

ToText({MyDate}, "dd-MMM-yyyy") or something similar

if your datetime is a field I suggest you to use other format option
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Do you intend to use your formula for display or in the record selection criteria?  If you use it in the record selection criteria then it won't be passed to the database server for processing.  How are you going to use the formula?
0
 
Gordon HughesDirectorAuthor Commented:
found the answer
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

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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