Hello Laura, Please change the field name, etc.. to match your data file -Alex
-----Original Message----- From: Alex Marshall [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 10:13 AM To: FusionPro Users Forum Subject: [fusionpro] RE: Date rule Hello Laura, Create an empty text rule in FusionPro and enter the following logic: //olddate = Field("TheDate"); olddate = "2006/20/5"; a = olddate.split("/"); return FormatNumber("00", a[2]-0) + "/" + FormatNumber("00", a[1]-0) + "/" + a[0]; Don't forget to check the box that says" Treat return strings as tagged text" regards, Alex Marshall -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 10:08 AM To: FusionPro Users Forum Subject: [fusionpro] Date rule Hello, I have a date field in my database that is 2007-09-01. Is is possible to make it print as 01-09-2007. Thanks in advance for any input. Laura -- 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 -- -- 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 -- -- 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 --
