Error when converting UTC to Central Standard Time in ADF

New Contributor

Hello All,


I am trying to create a parameterized subset folder name for a dataset as mentioned below

Structure : Bronze layer folder/Subfolder /filename.parquet

Subfolder code:

@concat('Raw-Status/',formatDateTime(addDays(convertTimeZone(utcNow(),'UTC','Central Standard Time'),dataset().paramDays),'yyyy-MM-dd'))


With this code, when I try to preview data in the dataset or refer as a source in dataflow, I get the error "the value provided for the time zone id 'Central Standard Time' was not valid. "


Could you please help with the right way of time zone conversion?





0 Replies