Good afternoon, we are trying to replicate some audit extract logic, and one of the challenges we are finding is the conversion of the Julian date to a "normal" date, for the functional purpose of retrieving the account period. We tried using the SQL DATEFROMPARTS function, but it is not supported on the data lake SQL implementation. Has anyone done this, in SQL preferably (Excel is easier, but the amount of records ISD would have to get and the logic is complex), or has syntax for it, or a workaround?
Right now, we are looking at a date of 2021001 and trying to get 2021-01-01 or something similar out of it, to get Period 1, for instance, and FY 2021.
