Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to calculate number of days between two dates except sunday. I have next table with data:
Like you see I don't have in my table sundays. I want to count how many time Item repeat. I need to get two table.
Fristtable:
Frist table show Item group by Source and number of repeat by date (date by date). The NumOfRep for Item I2 in Source S1 is 2 not 3 because repeat 25-05-2017 and 26-05-2017
Second table:
Second table show Item group by Source and number of repeat by date where date contains today date.
Any idea?
For second table, should S2 not also be there?
No, i need Item that repeat day by day but also contains date today()
And why not the combination of S1 and I2 ?
Because today is 29-05-2017 and S1 I2 repeat 25-05-2017 and 26-05-2017, it also exist 29-05-2017 but not repeat day by day (26-05-2017 29-05-2017)
OK, I was thinking in line to resolve it in the front-end itself. But now it seems that it has to be done at the back end.
Can you help me, give me some idea... I am new in QV
Idea - create a master calendar with all dates and may be create a flag field for Sundays. You can check this blog for detailed idea : How to populate a sparsely populated field
hm, it's not clear to me , I look blog but it's to hard to me