Skip to main content

Can I only insert Month, Day, or Years on the Date field?

  • November 12, 2018
  • 1 reply
  • 59 views
X
Forum|alt.badge.img+8
  • Xing
  • Known Participant

hi dear folks,
I want to ask a strange question which may not usual, but I want to have a field allows me to create the date only for “day”, “month”, or “year”, instead of to create the date record with “day, month, the year” all.
To be more precise, can I have a filed only leave the “1”, or “March”, or “2018”. Because currently, i would only be able to create the record for “March 1, 2018” all at one time.

Thank you.

    This topic has been closed for replies.

    1 reply

    J
    Forum|alt.badge.img+1
    • Jason_Gillman
    • Participating Frequently
    • November 12, 2018

    You could create a formula field for the individual components you want.

    So for example, if you have a date field called Actual Date, but you wanted just the full month, you could create a field called Month and use a formula similar to this:

    DATETIME_FORMAT({Actual Date}, 'MMMM')
      Terms & ConditionsAccessibility statement