Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi All,
While I was able to get this to work... it seems odd to have to do math by converting the time to a number and then applying math (+12 hours) and then converting back and concatinating...
I initially tried this but it didn't work... it only outputted Null... don't understand why...
DateTimeAdd([Sunset_Out], 12, "hours")
Can someone help me understand why? Does this function only work on Date and Time and not Time only? I also posted the question here:
Here's my updated solution, didn't like the previous, it was too messy. Much easier with 1 Datetimeparse formula.
My solution.
my approach