+3Hello,
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
Best answer by TheTimeSavingCo
Try using 'Qo' with the formula 'DATETIME_FORMAT()'
Here's a link to the specifiers available for use with DATETIME_FORMAT()
+15
@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! 😲
+31Try using 'Qo' with the formula 'DATETIME_FORMAT()'
Here's a link to the specifiers available for use with DATETIME_FORMAT()
+15Try 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" 👽
+3Try using 'Qo' with the formula 'DATETIME_FORMAT()'
Here's a link to the specifiers available for use with DATETIME_FORMAT()
Thank you:
+3Your 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.