Help

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

Topic Labels: Formulas
Solved
Jump to Solution
2147 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" 👽

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