get current year

[abyss]

hi
hi all, i am trying to get current year value from transformer stage, the way i do it is:

Code: Select all

DateToDecimal(CurrentDate(),"%yyyy")

and it output warning message：

Code: Select all

APT_CombinedOperatorController(1),0: Conversion error calling conversion routine decimal_from_date data may have been lost

does anyone know why?

thanks
abyss

[ArndW]

What did you define the target column as? I think if you make it a decimal field with 4 or more digits you shouldn't get this warning.

[ray.wurlod]

Why not use YearfromDate() function?