Dates per fortnight

[cristianj23a]

Hi guys.

I have the following case.

In the company where I do the project, they make payments every fortnight and end of the month. Then you have to create a filter by fortnight and end of month. Example.

I made an example to get fortnights but since the months do not have exactly 30 days, it does not work. Examples.

As shown in the image, filter the year 2017 and fortnight 27, should show the days 16 to 31 and in the fortnight 26 should show the days 1 to 15.

Please help me with this topic.

I attach the qvw.

Greetings.

[sunny_talwar · Accepted solution]

May be try this

AutoNumber(Month(Date)&If(Day(Date) <= 15, 1, 2)) as Fortnight_New,

[olivierrobin]

hello

I would try this :

SET Fortnight = if(day($1)<=15,(month($1)-1)*2+1,month($1)*2);

[cristianj23a]

thank you Sunny.

regards.

[cristianj23a]

thank you Olivier.

that code also works.

regards.