Find the first day's data of each month/quarter

[mhmhmh91]

Hello,

I have a table which has a field Date. I now want to display the data of the first day of each month or quarter. However, some dates are missing. For example, I don't have data on 01/01/2017 but I have data on 01/02/2017. In this case I want to display data of 01/02/2017. Can anyone tell me how to do it?

Thanks in advance,

Mandi

[sunny_talwar]

If you do then try this

Left Join(Visual)

LOAD Visual.Month,

  Min("Visual.Report Date") as "Visual.Report Date",

  1 as Flag

Resident Visual

Group By Visual.Month;

[mhmhmh91]

Got it! I worked it out. Thank you very much