0

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

null
    • Customer Service Ninox
    • Maria_pasini
    • 3 yrs ago
    • Reported - view

    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")

Login to reply

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 763Views