Date issue

[upaliwije]

Hi

I have developed a QV doc which I have attached herewith. There are 3 records relating to 3 different dates for the Months of May & Jun 2017. But I select a particular month the expected results are not show eg When I Select month of May the following appear.

But two records relating to month of may should display.  Pls check my QV doc and help to correct it

[kamal_sanguri]

There are chances that the records which are not visible in chart may not have correct date format. Please use this script to change and ensure that you have all the items in correct date format.

Date(PROV_DATE,'MM/DD/YYYY hh:mm:ss TT') as PROV_DATE

[vinieme12 · Accepted solution]

Do not use a Timestamp to create a MasterCalendar ; always only keep the date component

Modify the field to only keep date

Date(Floor(PROV_DATE),'MM/DD/YYYY') as PROV_DATE