Date Format

pbhupal · July 7th, 2004, 08:12 PM

Hello,

I am looking for a date in july 4, 2004 format but getting in mm/dd/yyyy. How can I achieve my goals with least coding?

formatdatetime(Trim(Rs("Start_Date")), vblongdate) - gives the day of the week that I do not want. Any help would be appreciated. Thanks

Paul

rodmcleay · July 7th, 2004, 08:23 PM

This will do the trick.

Code:

function diplayDate()
    useDate = Trim(Rs("Start_Date"))
    diplayDate = monthName(month(useDate)& " " & day(useDate) & ", "  & year(useDate)

end function

***Syntax not tested, and I don't type well***

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================