Question
how to convert a workday function output to Date & Time instead of just date
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.
