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