[fusionpro] RE: FusionPro date conversion
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, "); ld = long day (Monday, Tuesday, etc.) lm = long month (June, July, August, etc.) dd = two digits for the day (15, 16, 09, etc.) = 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 --
[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, "); ld = long day (Monday, Tuesday, etc.) lm = long month (June, July, August, etc.) dd = two digits for the day (15, 16, 09, etc.) = 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 1:04 PM To: FusionPro Users Forum Subject: [fusionpro] FusionPro date conversion Hello everyone! I am using a customer-provided CSV file (Excel) and one of the fields has a date. The date is formatted like this: 11/02/2007 I am trying to figure out how to write a rule or alter an existing rule to make the date appear as this (without changing the customer's file): November 02, 2007 If anyone has any idea how to do this, please let me know! It would be greatly appreciated. Thanks!!! ~Summer Cutler +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 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 -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 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 --
[fusionpro] RE: FusionPro date conversion
Try this: var date = Field("FieldDate") var gtdate = FormatDate(date, "lm dd, ") -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 1:04 PM To: FusionPro Users Forum Subject: [fusionpro] FusionPro date conversion Hello everyone! I am using a customer-provided CSV file (Excel) and one of the fields has a date. The date is formatted like this: 11/02/2007 I am trying to figure out how to write a rule or alter an existing rule to make the date appear as this (without changing the customer's file): November 02, 2007 If anyone has any idea how to do this, please let me know! It would be greatly appreciated. Thanks!!! ~Summer Cutler +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 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 -- To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 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 --