I have a date field "Date", then I tried to use Week({{Date}}) to get the week# of the date in a year for a Number field. However, I got following error: Could not convert the field value to a number. Please ensure the value is a number, math expression or smart-value that can be converted into a number.
I wanted to get the day# (in a week, month, year), week#, month#, year of a date, if possible.
