Cannot convert value date to type Function

[billybazinga]

Hi everyone,

I have a function in my code which specifies today's date, under this form: Date.Today = Date.From(DateTime.LocalNow())

I have a new column with the following code returning the error on the screenshot and I can't for the life of me figure out what is going on. I have tried to add Date.From in front of Date.Today but to no avail. Any ideas?

if [Date_Receipted]<>Date.NotDelivered 
or Date.Year([#"Date_Promised (calculated)"]) > Date.Year(Date.Today)
then null 
else "Week "&Text.From(Date.WeekOfYear([#"Date_Promised (calculated)"])-Date.WeekOfYear(Date.Today()))

[Vijay_A_Verma · Accepted solution]

Issue is due to the fact that you have use Date.Today() which should have been Date.Today

[billybazinga]

Thank you very much, I obviously looked at this far too much and missed it 🙂