Customised datatype for date

[Guest]

Hello

I want to display birthdays in a table, but dont want to have the year shown
(some people might be sensitive about their age). By the looks of things
none of the usual date datatypes allow this. I am using text at the moment
and the users have to type in 01 Jan.

It would be nice if you could add the date as 1/1 (01 Jan) and then it
automatically comes up as 01 Jan or 01 January (as with medium date and long
date). Is this possible or not?

Thanks for any suggestions.

 

[Joseph Meehan]

Hello

I want to display birthdays in a table, but dont want to have the
year shown (some people might be sensitive about their age). By the
looks of things none of the usual date datatypes allow this. I am
using text at the moment and the users have to type in 01 Jan.

It would be nice if you could add the date as 1/1 (01 Jan) and then it
automatically comes up as 01 Jan or 01 January (as with medium date
and long date). Is this possible or not?

Thanks for any suggestions.

Sure it is a format issue. Try "d mmm" That will give you 1 January.
"dd mm" should give you 01 Jan.

 

[Guest]

Brilliant! Thanks very much, you're great!

Sure it is a format issue. Try "d mmm" That will give you 1 January.
"dd mm" should give you 01 Jan.

 

[Joseph Meehan]

Brilliant! Thanks very much, you're great!

Thanks for letting us know it worked for you.