RE: CF function to manipulate a date

[Adkins, Randy]

You can use the actual  functions built
into CF:

Month(myDate)
Year(myDate)

If you need a 4-digit Year:
DateFormat(myDate,"")

HTH


-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 11:54 AM
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a 
another year field and to another month field.  How do I "string" out myDate

inorder to seperate the mm and  section of it so I can compare each 
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF function to manipulate a date

[John Wilker]

In CF you could use the DateFormat() function and put a mask of just mm or
 for each of the compares. In SQL you could use the Month() and Year()
functions for the respective compares.

Hope that helps

J.

John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer

www.red-omega.com 

"Losing - If at first you don't succeed, failure may be your style."
~despair.com


-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 8:54 AM
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a
another year field and to another month field.  How do I "string" out myDate
inorder to seperate the mm and  section of it so I can compare each
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF function to manipulate a date

[James Maltby]

Use something like:




Then use the two vars myMonth and myYear to compare.

I guess

James

-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 16:54
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a 
another year field and to another month field.  How do I "string" out myDate

inorder to seperate the mm and  section of it so I can compare each 
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF function to manipulate a date

[Larry Juncker]

YOu could use




Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 10:54 AM
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a
another year field and to another month field.  How do I "string" out myDate
inorder to seperate the mm and  section of it so I can compare each
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists