ConvertToLocalTime() and year(),month(),day()

[#1]

Hi folks,

I've got a problem concerning the ConvertToLocalTime() function in combination with the functions year(), month() and day(). The converted datetime field is correct and will yield the correct year, month and day, if I use the functions directly on the sheet. However, if I want to write them as fields into a table in the script, I get a weird format (for example, the year 2011 will be written as 03.07.1905 02:00:00). I tried several different approaches to solve the problem (various conversions and modifications in different combinations), but it didn't work out.

Does anybody know the problem and maybe have a solution? Every advice is highly appreciated.

Thanks everybody!

Christian

[swuehl]

Could you post your script here (or the relevant part where you try to convert the datetime field)? Also your standard format settings and some example field values as read from your database might be useful.