DateTime type - SQL Backend

[Guy]

Hello,__I have a problem with Date Type in my reports. Sometimes in a report i pick a field with type DATE and sometimes for the same field in the same file, but in other report the type is DATETIME. I don^t know why ? Can you explain me ?__Thank you.____RR v11.006__Ms SQL 2000__

[kfleming]

If the report was created in an earlier R&R release, there was an option to convert date fields to datetime when the report was saved in a newer version. So your reports that use date instead of datetime are probably older reports where retain date rather than datetime was selected.____Kathleen__R&R Support

[Guy]

[updated:LAST EDITED ON Aug-17-05 AT 11:27 AM (EST)]Kathleen,__Hum,It^s possible (certainly), but now how can i convert this reports.__A other thing, why in a same report i have fields with type DATE and DATETIME ? The conversion you say it^s for the complete report ? isn^t it ?

[Guy]

Hello,__Any solution for me ?__Please

[kfleming]

The conversion would only apply to the date fields that were used in the report at the time of conversion.____Is the current problem that you want all of your date time fields to be treated as dates? The only way to do that would be to create a calculated field to perform the conversion.____Kathleen__R&R Support

[Guy]

But i don^t know how.__I have a field of type DATE, and i would like the time of this field.__What function must i use for this.__Thanks__

[Guy]

Kathleen,__I always the problem. Please.__

[kfleming]

Try re-selecting the data table that contains the datetime field. So if it were the master file you would use Database Master Table and then re-select the table.____At that point it will remove the date field and you can re-insert the field that will then be a date time. If you have calcs that depend on this field, you may need to make further edits as well.____Kathleen__R&R Support

[Guy]

Ok i try it__thank you__