In the date and time formula examples, I’m guessing the capital letters, A, X, and Y, are dates. How are they supposed to be formatted to work in calculations? I’m simply trying to set up a calculation to give me the number of days between a certain date in the past and today.
Hi Mark,
Use the DAYS() function to do that.
DAYS(TODAY(); [Due Date])
So the format is just the field name. On iOS it’s surrounded by square brackets. On macOS you just double-click on the Date field on the formula editor to insert the field into the formula.
Thanks,
Brendan
Attachments:
You must be
logged in to view attached files.
.
