PDA

View Full Version : dates in general format

deekras
11-07-2001, 07:29 AM
i have a date field that i want to add a number to. this works fine.
NEW END DATE: Format(DateAdd("m",+[payment schedule],[PAID THROUGH]))

but i want to see it as May 1, 2001 not 05/01/01. how can i do that?
cpod
11-07-2001, 08:43 AM
NEW END DATE: Format(DateAdd("m",+[payment schedule],[PAID THROUGH]),"mmm d, yyyy")