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
--
