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

1+floor((($month$+1)%12)/3)

 

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

 

Best, Iris