Am trying to find week number in snowflake and am trying the below query. select week (to_date('2022-01-01')) and expecting result as 1 because first day of year. But its giving result as
Solved: PowerApp: Calendar Week Number Picker - Power Platform Community