I am using Databricks and it does not allow setting the date to legacy (pre version3.0) mode. So then given (year, week-in-year) how can any of the dates within that week be returned?

All the answers that I have found do require setting LEGACY and I’ve tried it: Databricks runtime will not allow setting it.

spark.conf.set(“spark.sql.legacy.timeParserPolicy”, “LEGACY”)

https://community.databricks.com/t5/data-engineering/getting-date-out-of-year-and-week/td-p/6021