Formating date

[rohnds]

I have date column and not all the data have day, month and year. Some of the data only have month and year.
How can I create a format such that when I enter,
say 7/2001
It should display : July 2001
But if I enter:
say 3/7/2001
It should display : July 3, 2001


Thanks

Rohn

 

[speakers_86]

use the format function in the after update event.