Thanks in advance.

How can you show the date in the form of

1st Day of November
20th Day of January

regards,

Jin

--
Jin

I used the fcardinaldate function submitted by Marshall Barton, works
great on my report.

Just incase you don't know how to create the function:  Enter the code
in a module.  When you use expression builder you can select the
function from database functions (under built-in functions).

I have been meaning to have a go myself - I'll let you know if I have any
success.....

....unless anyone out there has already done it, that is.

Jonathan

Here is the function that works for me in a report:

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