Link to home
Start Free TrialLog in
Avatar of Gordon Hughes
Gordon HughesFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
Avatar of Vinicio Guzman
Vinicio Guzman
Flag of United States of America image

right click on the field, choose 'date and time' field, then select a date format you like
Avatar of Gordon Hughes

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Gordon Hughes
Gordon Hughes
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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?
found the answer