>Hi Cetin,
>
>Thanks for the input, but I found the solution. The way I made the views was allright but I just had to USE it ones more to for all the changes to take effect. There is still one thing that puzzels me: If I Select * from AnyTable Wich has empty datafields the resultset will have empty datafields. This is not the case with this view or any select out of this view. The empty datafields will result in {30 dec 1899}. Do you have any idea how to avoid this behaviour?
Mark,
This is from VFP help :
"DateTime Data Type
Choose the DateTime data type to store values that are either dates or times, or both. A DateTime value is stored in eight bytes — two four-byte integers. The first four bytes represent the date. The remaining four bytes represent the time in milliseconds from midnight. DateTime values can contain both a date and a time, or only a date or only a time. If you specify no date value, Visual FoxPro adds a default date of December 30, 1899. If you specify no time value, Visual FoxPro adds a default time of midnight."
Similar explanations for datetime functions. Local views doesn't have this problem.
Cetin