jaxflorida
Technical User
Hello,
When I run my crosstab comparing a table with ONLY dates in a field with another table containing dates with timestamps, my query does not return the records that had timestamps with the date. I more or less understand why it does this, but I can't seem to convert the field to something that the crosstab can match up with.
To illustrate, I have a record with a time/date field that shows 8/21/02 9:15am (call it record A) and a record with just 8/21/02 (record B). When I run a crosstab query comparing a another table that has a record 8/21/02, it only returns one record - the 8/21/02 (record B).
Can someone please help me. It is fairly urgent!
Thank you
When I run my crosstab comparing a table with ONLY dates in a field with another table containing dates with timestamps, my query does not return the records that had timestamps with the date. I more or less understand why it does this, but I can't seem to convert the field to something that the crosstab can match up with.
To illustrate, I have a record with a time/date field that shows 8/21/02 9:15am (call it record A) and a record with just 8/21/02 (record B). When I run a crosstab query comparing a another table that has a record 8/21/02, it only returns one record - the 8/21/02 (record B).
Can someone please help me. It is fairly urgent!
Thank you