You need to sign in to do that
Don't have an account?
HaydenMuhl
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?
What would be the best way to store this?
What about using formula fields and using the function, MONTH, DAY, YEAR to break up a date value?
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.