Date extractor node - offset required for Quarter

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



This is mapping November to 1, December to 1 and so on


Best, Iris