Date Field Format
I am compiling a database for the large number of subscriptions I maintain. How do I format the following:
1) A field that only shows the date of the month that monthly subscriptions renew? Note: I want this to be a date field — but I don't want the month and year shown since the product renews monthly.
2) A field that only shows the month and day of that month that each yearly subscription renews? Note: I want this to be a date field — but ideally I would only want the month & day to show since the product renews yearly. I know about the "anniversary" checkbox — so maybe that works. However, ideally, I would only like the month & date shown.
BTW, I use the Mac app with iCloud.
Thanks for your help.
1 reply
-
Dear Robert,
You could leave the date hidden (or make it visible only if you click a certain button, like a 'Yes/No' field) and create a formula field wih the date in the format that you want:format(Date,"YY/MM/DD")
or if you want only the date:format(Date,"DD")
Content aside
- 4 yrs agoLast active
- 1Replies
- 779Views