Dick
That looks like a date time field.
I never thought much about it, but I don't think that cfhttp can
determine that the field is a datetime -- I think it simply creates a
char field.
So, you can't do a QofQ on a datetime value as only text comparisons
are valid.
A possible solution is to:
1) loop through the query
2) convert each text representation of date time into a valid datetime
object
3) perform your comparison
4) build a new query with a row for each match
HTH
Dick
> The file is something like
> Part,PartDesc,OrderRef,Qty,orderdate
> XX9999,A descriptoin of an Item,OrderRefno222,1,14/05/2004 15:20
>
> you get the idea
>
> It is the date that kills me!
>
> MD
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
