Gordon Hughes
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
I want to convert it to date only
what formulae do i use
Gordon
right click on the field, choose 'date and time' field, then select a date format you like
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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?
ASKER
found the answer