Thanks Cody, That worked. But, after that was done the users wanted the month to be spelled out so that if date_var had value Jan 5, 2010, they wanted January 5, 2010.
I googled for the Live docs and changed the mask as #DateFormat(date_var, "MMMM-DD-YYYY")# which did it. Thanks for your advice and time. ________________________________ From: Cody Wehunt <[email protected]> To: "[email protected]" <[email protected]> Cc: "[email protected]" <[email protected]> Sent: Sun, October 3, 2010 11:47:12 PM Subject: Re: [ACFUG Discuss] newbie question: formatting a date variable 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 <[email protected]> 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 >------------------------------------------------------------- ------------------------------------------------------------- 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 http://www.fusionlink.com -------------------------------------------------------------
