Calculation

[rebamanu]

Hi,
i need to calculate the aggregate current balance using 3 variables..the End of Month Date,Date opened and the current balance..expression given is
End of Month Date([YYYYDDD) - Date Opened <= End of Month Date(DDD) then
aggregate current balance / End of Month Date (YYYYDDD) - Date Opened + 1 else
aggregate current balance /end of month(DDD)

How do i implement in transformer stage..I tried Days since date but throws up error saying :Data string '%yyyy-%mm-%dd' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %yyyy.
Thanks
Reba

[ArndW]

Your format string should match the data as in "%yyyy%ddd"