Dates in Reports

[seanog2001]

i want to have the date in my report which is in letter form in the following format

21st July, 2006
22nd July, 2006
15th July, 2006 etc etc

How do i do this

I have it set up but its coming up like this

25 July, 2006

 

[mhartman]

Hello:
Enclosed below are the custom formats for the format property of your date text box:
'
dd"st "mmmm", "yyyy
dd"nd "mmmm", "yyyy
dd"th "mmmm", "yyyy
'
Regards
Mark

 

[MStCyr]

Here's a function that may be useful


Function fCardinalDate(bytDay As Byte) As String
Select Case bytDay
Case 1, 21, 31
fCardinalDate = bytDay & "st"
Case 2, 22
fCardinalDate = bytDay & "nd"
Case 3, 23
fCardinalDate = bytDay & "rd"
Case Else
fCardinalDate = bytDay & "th"
End Select

End Function