[tjamnz]

I would like to "Build" an expression for a date/time field that will query the date and display my query output as "01/01" or "January, 1st", and leave off (omit) the year.

Im trying to print a report of my employees birthdates without displaying the year, so i can post it publicly.

the name of the column is dob (date of birth) and the format is standard date/time, displayed normally as 01/01/2009 etc ....

The best idea i could come up with so far is

= Format (Date(), "dddd, mmm d")

but this displays todays date and not the date stored in my column lol.

[Zack Barresse]

Hi there,

Can't you change out "Date()" for your field name?

Edit: Also, the format in your formula doesn't match what you're asking for. The format for that would be "mm/dd".

[tjamnz]

I'll try that in the morning.

however, I dont think i can functionalize () (lol) my column name though

[Zack Barresse]

Either I'm tired and missed the joke or... or I'm tired and missed something altogether. LOL!

You're doing this for a report, right? You should just be able to reference that field, i.e. TableName!FieldName. Let us know how it goes.

[tjamnz]

cool thanks.

.... someone at work asked me for help, and i said i'd look into it.

[Zack Barresse]

That's how it starts. Be careful... it's addicting!