convert date format YYYY.MM.DD to YYYYMMDD

Hi All,

I request assistance to alteration the VDATU tract day format from YYYY.MM.DD (2024.12.30) to YYYYMMDD (20241230) utilizing BODS functions.

I tried to_char, it's giving expected format lone aft changing the datatype of file to varchar successful query mapping. If I'm changing to day datatype, its giving null value.

tried to-date(to_char(2024.12.30,'YYYYMMDD'),'YYYYMMDD')--this besides giving null.

Thankyou for your assistance successful advance.