Further to Alex's post (thanks Alex!), here are other options for formatting the date:
sm = short month (Jan, Feb, Mar, etc.) mm = month number (01, 02, 03, etc.) ld = long day (Monday, Tuesday, Wednesday, etc.) sd = short date (Mon, Tue, Wed, etc.) d = digit for the day (one digit for 1-9, two digits for 10-31) Rob -----Original Message----- From: Alex Marshall [mailto:[EMAIL PROTECTED] Subject: [fusionpro] RE: FusionPro date conversion Hello, If you just want to take today's date, here's the rule: return FormatDate(Today(), "ld, lm dd, yyyy"); ld = long day (Monday, Tuesday, etc.) lm = long month (June, July, August, etc.) dd = two digits for the day (15, 16, 09, etc.) yyyy = the entire year For today, this rule returns "Friday, June 15, 2007" You can also replace the Today() with Field("Date") to get the field data your user entered. Alex +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Calling all FP Web Users! Do you have a question or lots of knowledge to share about FusionPro Web? If so, join our Printable Web to Print Users' Forum today! Send email to [EMAIL PROTECTED] to find out how! +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --