The date column shows only the date of the beginning of the quarter

Platform discussions
1

Hi,

how can I make a date column that shows only the date of the beginning of the quarter

for example -
01.07.2024 - when this quarter end I want it to show the begining of the next quarter

01.10.2024 - when this quarter end I want it to show the begining of the next quarter

01.01.2025 - etc

2

Hi @eranggg ,

You can try this Formula

IF(MONTH({Date}) <= 3, “1/4/” & YEAR({Date}), IF(MONTH({Date}) <= 6, “1/7/” & YEAR({Date}), IF(MONTH({Date}) <= 9, “1/10/” & YEAR({Date}), “1/1/” & (YEAR({Date}) + 1))))

It shows the beginning of the next quarter when your date column reaches its end

If you need any implementation support kindly contact us

MSquare Support
Visit us here
Youtube Channel

3

I won’t be able to use it in the automations.
that’s the problem

4

Hi Eran,

You can use the Advanced Formula Booster App for this. The Advanced Formula Booster casts its results to regular columns. It does NOT use the formula column.

You could create this formula:

2024-04-24_10-09-54

Then create an automation that runs the formula at every end of the months. If it is not an end of quarter month, then the formula won’t do anything, otherwise it will write the date of the first of the following month to a regular Date column.