Help

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

3865 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Xing
6 - Interface Innovator
6 - Interface Innovator

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.

1 Reply 1
Jason_Gillman
6 - Interface Innovator
6 - Interface Innovator

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