Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the day# (in a week, month, year), week#, month#, year of a date?

Jiazhu Hu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 2, 2023

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. 

1 answer

0 votes
Brant Schroeder
Community Champion
November 20, 2023

@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?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events