Querying a date

[paultri]

I am trying to query a table by date but the datatype for the date is set to text, unfortunetly i am unable to change it to "date/time" is there anyway for me to create a query that will query by date without changing this? any help is appreciated!!

thanks

Paul

 

[Mile-O]

Can't you just copy the table (just in case), change the data type to Date/Time, and see if there are any conversion errors.

Also, for queries, there is the CDate function. Look it up in the help files.

 

[paultri]

I can just copy the table, however it is over 600 megs and it takes some time and plenty of system resources, it is added to every day so i would have to copy it everyday that i would want to run the query.

Thank you! I will look into the cdate!!

Thanks

paul

 

[Mile-O]

When I said copy - I just meant to test if conversion causes any errors (i.e. anything in the text field that can't be evaluated as a date)

If there is no errors then I don't see why you can't just convert the data type of the original table and continue to import as per normal.

 

[paultri]

I only have read rights to the data, so the only way for me to change the data is to actually import the table and then convert it that way, but i would have to do that every time because the table is constantly updated. Its pulling this table from a foxpro database.