Jun 14 2022 01:01 PM - edited Jun 14 2022 06:53 PM
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?
Regards
AddyGR28