>>Interesting naming convention
>
>Which?
>
>>Your original table has date in character format. When you produce CSV can you change it to date (use CTOD, if you want)?
>
>Do you mean IntermTable? That has just been created by importing the XLS. How can I use CTOD() in that process?
>I had no initial input in the production of the XLS/CSV, but had to reformat it somewhat to get it to feed to this program.
>
>Si ... don't understand. Thanks
>
I guess, I misundertstood you originally. Ok, your intermTable is from Excel, which explains strange names for the fields. And in your IntermTable dates are in C format, correct? What do you receive when you convert these dates back to date? Of they already come wrong?
Thanks.
If it's not broken, fix it until it is.
My Blog