Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • 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
GiaHughes
Asked:
GiaHughes
  • 3
  • 3
1 Solution
 
vguzmanIT ManagerCommented:
right click on the field, choose 'date and time' field, then select a date format you like
0
 
GiaHughesAuthor 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
GiaHughesAuthor 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
 
GiaHughesAuthor Commented:
found the answer
0

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
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now