Customised datatype for date

[mix]

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.

 

[mix]

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.