Date Question

[neomorpheus]

If I have the value of a CreateODBCDate(Now()) as {d '2002-04-16'}. If I wanted to convert this to a numeric type...what should I do??

for eg:

For example, in ColdFusion, a numeric value 37287 will interpret to 1/31/2002.

Now how can I convert my date to numeric?? Thanks

 

[neomorpheus]

<cfset DateEnd = CreateODBCDate(Now())>
this returns the value: {d '2002-04-16'}.

<cfset DateEnd = CreateODBCDate(Now()) + 0>
this returns the value as 37362.
Equivalent to {d '2002-04-16'}.