Easy if you know how

[colmoore]

Hi all,

I am making a query which sorts birthdays into chronological order.

I have used the DatePart function to determine the month:

DatePart("m",[DATE OF BIRTH])

But I want to know how to display the month in CAPITAL LETTERS, i.e. instead of reading 1 it reads JANUARY

Thanks in advance

 

[andrew93]

Hi

Try using this instead :

Format(Format(Month([DATE OF BIRTH]),"mmmm"),">")

HTH, Andrew

 

[colmoore]

Close!

Hi andrew,

Thanks for this. They're all coming out as JANUARY though

Any ideas???

 

[Bat17]

Alternativly just wrap you function with the MonthName() function and stick the ">" in the Format filed of the control

CapMonth: MonthName(DatePart("m",[DATE OF BIRTH]))

peter

 

[Rich]

Format([DOB]"MMMM")

 

[Bat17]

Always at least 3 ways to skin a cat in Access

peter

 

[Rich]

Yes and I don't know why the DatePart function is being used at all here,
Month([DOB]) will return the numeric value to sort on

 

[ScottGem]

If you want to sort the birthdates for the current year use:

CurrBirthDay: DateSerial(Year(Date()),Month([DOB]),Day([DOB]))

This will display the birthdate for the current year so it can be sorted chronlogically.

If you then want to display the date in a specific format you can use the Format function.