In CF you could use the DateFormat() function and put a mask of just mm or
yyyy 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 <http://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 mmyyyy 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 yyyy 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
