Trying to add # of days to a date but don't want time displayed

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!
image

Hi Kevin<

Have you tried the format() formula?

Regards
piet

2 Likes

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!

4 Likes

I think your best bet would be DateTimeTruncate function. In your case, it would be something like

DateTimeTruncate(Today() + 90, "day")

image

4 Likes

Always so many ways… :wink:

3 Likes