Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Formula to convert date into quarter add display it in full text

Topic Labels: Formulas
Solved
Jump to Solution
2602 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Remy_K
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

I would like a formula to convert date fild  into quarter and  add display it in full text.

Exemple:

Dates between 01/01/23 to 31/03/23  will display " first quarter"

Dates between 01/04/23 to 31/07/23  will display " second quarter"

and so on...

Thanks for your precious help.

 

Remy

 

 

 

 

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try using 'Qo' with the formula 'DATETIME_FORMAT()'

Here's a link to the specifiers available for use with DATETIME_FORMAT()

See Solution in Thread

5 Replies 5
Grunty
7 - App Architect
7 - App Architect

@Remy_K wrote:

I would like a formula to convert date fild  into quarter and  add display it in full text.

Exemple:

Dates between 01/01/23 to 31/03/23  will display " first quarter"

Dates between 01/04/23 to 31/07/23  will display " second quarter"

and so on...


Care what you wish! 😲

TheTimeSavingCo
18 - Pluto
18 - Pluto

Try using 'Qo' with the formula 'DATETIME_FORMAT()'

Here's a link to the specifiers available for use with DATETIME_FORMAT()

Your suggestion would work for a conventional request. However I don’t think it would work for the present case.
He’s asking for a formula that assigns July dates to "second quarter" 👽

Remy_K
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you: 

DATETIME_FORMAT(
  SET_LOCALE({Date},'fr'), 
  'Qo'
)
This works But only returns 1er,2,3,4 instead of 1er,2éme,3éme,4éme. Weird...

 

Remy_K
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you