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.
@Jiazhu Hu Welcome to the Atlassian community
Are you trying to get this in an automation? Can you share a screenshot of what you are trying to do?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.