how to convert a workday function output to Date & Time instead of just date

Certified Associate Developer

Hi All,

I want the output of a workday function to be Date&Time instead of just Date. Please advise on how I can wrap the below logic to get the output as Date& Time:

workday(
todatetime("01/01/2024 7:01 AM"),
(
dayofyear(
caladddays(todatetime("01/01/2024 7:01 AM"), 0, "Default Calendar")
) - dayofyear(todatetime("01/01/2024 7:01 AM"))
),
datetime(2024,01,01)
)

I need the output to be 1/2/2024 7:01 AM instead I just get 1/2/2024.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data