This basic stuff makes me feel so stupid and Googling has not helped so apologies ahead of time.
I have a date field on the canvas (called service-date) - it’s where I enter an employees start date. I want to display the date they start earning sick days which is 90 days after. When I do =service-date + 90 it gives me the proper date but also displays a time. I don’t want the time. Please help!
Hi Kevin<
Have you tried the format() formula?
Regards
piet
Hey there!
The most efficient/easiest method would be to chain a .toDate() at the end of your formula. So your end formula might look something like this:
(service - date +90).toDate()
Let me know if that works!
I think your best bet would be DateTimeTruncate function. In your case, it would be something like
DateTimeTruncate(Today() + 90, "day")
