You can use a combination of the DATE and FORMAT function. The DATE function to convert the BLDAT date string to a date which then can be used by the FORMAT function to create a NVARCHAR typed result in your format.
The expression for the column engine calculated column looks like following:
format(date("BLDAT"),'YYYY/MM/DD')
Regards,
Florian
Add comment