In the date field extractor node there is no possibility to offset start of year quarter, it currently starts at Jan 1. In the data I have the first quarter starts on Nov 1, is there a way I can get the 1st quarter to start on Nov 1?
Many thanks.
In the date field extractor node there is no possibility to offset start of year quarter, it currently starts at Jan 1. In the data I have the first quarter starts on Nov 1, is there a way I can get the 1st quarter to start on Nov 1?
Many thanks.
Hi tjc,
I think we never thougt of this case when we designed the node.
But you can easily work around.
First. Use the date field extractor and extract the month.
Than add a Math Formula node and use the following formula
1+floor((($month$+1)%12)/3)
This is mapping November to 1, December to 1 and so on
Best, Iris