Forum Discussion
Token EOF Error
I am getting a token eof error on this query and I am not sure why. The week variable prints 26 when I run this with out the database part. let week = Date.WeekOfYear(DateTime.LocalNow()) in w...
Now what will your query do on Jan 1st 2021? 🙂
warmer, How do I concatentate 2020 and week? It needs to look like data-resilient-all-202026
Expression.Error: We cannot apply operator & to types Text and Number.
Details:
Operator=&
Left=data-resilient-all-2020
Right=26
Right, i forgot your week is a number.
Which brings up the next question - are weeks 1 to 9 supposed to come over with one digit or two digits? Ie "2" or "02" for week 2?
Assuming "02" you would do
Number.ToText(week,"D2")