The date mask is wrong for what you describe you are wanting. But try the line below and let us know what you get, errors or output.
#DateFormat(date_var, "MM-DD-YYYY")# Sent from my iPhone On Oct 3, 2010, at 11:37 PM, Chris H <h_chris...@yahoo.com> wrote: > I want to format the value of date which is in a variable(date_var) in > MM-DD-YYYY format and print it in a document. So, if date_var has value Jan > 5, 2010 I want that to be printed as 01-05-2010 > > > <td> > DateFormat(#date_var#, 'MMMM DD,YYYY') does not work > </td> > > > does not work. > > How can I do that? > > Any suggestions would be appreciated. > > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > -------------------------------------------------------------