Skip to main content
Question

How to show date and timestamp in formula field

  • February 1, 2023
  • 0 replies
  • 119 views
I'm adding two fields, one field is having Date and Timestamp and another field is Duration of  days. the output I want is Date/Time.

Output field type is Date/Time

ToDate([Request Received Date]) + Days([TAT]) 

Using above formula I'm getting the output in Date format, But I required in Date/ Timestamp

------------------------------
manohar vankireddy
------------------------------
This topic has been closed for replies.

  • AustinK
  • Registered
  • February 2, 2023
If the [Request Received Date] is actually starting out as date/time then just remove the ToDate function there as that is what is causing it to be converted to a date only and not have any time associated with it. You mentioned the output field type was date/time so I assume this meant your original field there.

You could also use ToTimeOfDay to pull the time out of the date/time field to begin with and work with it from there.

However if [Request Received Date] starts as a date only you cannot pull a time from it.
Terms & ConditionsAccessibility statement