function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
HaydenMuhlHaydenMuhl 

Storing Fiscal Year End

We have several fields where we need to store the date and month, but don't need the year. One example of this would be the fiscal year end for each of our clients. It doesn't look like the date data type lets you store just the month and date information.

What would be the best way to store this?
aalbertaalbert

What about using formula fields and using the function, MONTH, DAY, YEAR to break up a date value?

 

HaydenMuhlHaydenMuhl

Yes.  I had thought about using a date field and simply ignoring the year portion, but that just bugs me.

 

I'm playing around with having two fields.  A picklist of months and a two digit number field restricted by which month has been selected.