May 12, 2023 09:36 AM
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
Solved! Go to Solution.
May 13, 2023 04:39 AM
Try using 'Qo' with the formula 'DATETIME_FORMAT()'
Here's a link to the specifiers available for use with DATETIME_FORMAT()
May 12, 2023 01:52 PM
@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! 😲
May 13, 2023 04:39 AM
Try using 'Qo' with the formula 'DATETIME_FORMAT()'
Here's a link to the specifiers available for use with DATETIME_FORMAT()
May 13, 2023 08:04 AM
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" 👽
May 20, 2023 06:53 AM
Thank you:
May 20, 2023 06:53 AM
Thank you