Number to date conversion in idt

[former_member592846]

Hi,

I have one requirement like, I need to convert date from YYYYMMDD to MMDDYYYY in SAP IDT. But the problem here is the data is coming from snowflake database as number. I tried with multiple options but I didn't get the expected result. Can anyone suggest me the condition in idt to conver number to date format.

Thanks in advance

[ayman_salem · Accepted solution]

Try this:

in IDT: to_date(to_char(T1.DATNUM), 'YYYYMMDD')

then use the FormatDate([date]; format) in the WebI report.