You could also do it like this:
todaysDate=(Now()+0);
Andrew
Quoting Rae Bailey <[EMAIL PROTECTED]>:
> Thankyou,
>
> That worked :)
>
>
> Rae
>
> -----Original Message-----
> From: Heseltine, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 28 June 2001 9:40
> To: Spectra-Talk
> Subject: RE: Comparing dates
>
>
> todaysDate=(CreateODBCDateTime(Now())+0);
>
> -----Original Message-----
> From: Rae Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 28 June 2001 9:29
> To: Spectra-Talk
> Subject: Comparing dates
>
>
> Hi,
>
> How do you convert a date to numerical value to compare against the
> datetimedata column in the properties table. If you look at the
> properties
> table column datetimedata, all dates are represented as a numerical
> value. I
> need to be able to create today's date as a numerical value to compare
> against this table.
>
> Thanks in advance,
>
> Rae
>
> Rae Bailey
> Internet Media Consultancy Group Pty Ltd
> 02 4963 7855
> 0411 447 430
> http://www.imcg.com.au
>
> Proud supporters of the James Craig Restoration
> http://www.seaheritage.asn.au/jamescraig
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
