How can i get month,number of weeks from given date range?

0
When i give from and to dates i want to get month,number weeks in the same and i want to retrieve the forms count which are created in the date range and  how to show those counts in weekly basis. can anyone help on this? I have requirement like, count no of registration done when a user give “from” date and “to” date.For example, if a user give date range from  1st Jan 2020 to 16th Jan 2020.I have to count number of registration done during the user given  period.so i have to fill number of registration done on 1st jan 2020 to 5th jan 2020  in “ week number”  1 ,6th  jan 2020 to 12th jan 2020 in “week number” 2 ,13th jan 2020to 16th jan 2020 in “week number ” 3
asked
1 answers
0

Hi Shanthimeena,

Assuming the registrations are stored in your database, you could create a loop like this to create a datapoint for every week and count the amount of registrations using an XPath as shown below.

Does this help?

 

answered