R
Radhika
I have a qry that calculates the difference in time between VPInsertionDate
and VPRemovalDateB in an expression called 'Time'. This difference in dates
leads to '#Error' where I eliminated values that should be present. I want to
isolate all values for 'Time'>180. However, due to '#Error' being present in
the 'Time' column along with the DateDiff I need, I get a message saying
'Data type mismatch'. How can I do isolate values 180?
Thank you
Shukla
and VPRemovalDateB in an expression called 'Time'. This difference in dates
leads to '#Error' where I eliminated values that should be present. I want to
isolate all values for 'Time'>180. However, due to '#Error' being present in
the 'Time' column along with the DateDiff I need, I get a message saying
'Data type mismatch'. How can I do isolate values 180?
Thank you
Shukla