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


#1

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.


#2

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