Forum Discussion
AddyGR28
Jun 14, 2022Copper Contributor
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