[fusionpro] RE: FusionPro date conversion

2007-08-23 Thread Rob Domaschuk
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

2007-08-23 Thread Alex Marshall
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

2007-08-23 Thread David Galvan
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
--