- see footer for list info -<
Paul,
You know you should really use create date for this, and then it would
be correct all the time.
Thanks,
Tom
Paul Swingewood wrote:
- see footer for list info -<
This one just doesn't make sense .....
I have a start and an end date .... I compare the two to see if the end
is before the start.
It just doesn't work .....
<!--- This is what comes from the form --->
<cfset FormStartDate = "31/10/2005">
<cfset FormEndDate = "02/11/2005">
<!--- Now convert this to actual ODBC dates --->
<cfset NEwstartdate = CreateODBCDateTime(FormStartDate)>
<cfset Newenddate = CreateODBCDateTime(FormEndDate)>
<!--- If the End is befoe the start then its an error --->
<cfif DateCompare(NewEndDate, NewStartDate) EQ -1>
<cfoutput>
Error <br>
Start = #NewStartDate#<br>
End = #NewEndDate#
</cfoutput>
</cfif>
<cfabort>
This is crazy the 2 dates are displayed correctly and are in ODBC format.
Anyone tell me whats going on here please ...?
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
