Skip to main content

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

 

 

 

 

 


@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! 😲


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

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


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" 👽


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

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


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...

 


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

 


Reply