Forum Discussion

AddyGR28's avatar
AddyGR28
Copper Contributor
Jun 14, 2022

Error when converting UTC to Central Standard Time in ADF

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

 

No RepliesBe the first to reply

Resources