How to display list of missing dates for a specified month in a text box

[nivitha18]

I want to be able to list any missing dates for a specified month in a text box.

i.e.

Object1 has some dates in July missing, so I want to be able to see a list of the dates that are missing in a text box.

Within my data, I haven't got values against those dates.

I have attached a sample data sheet and qvw.

Please if someone can help me with this.

Thank you.

[Anonymous · Accepted solution]

try

concat(distinct {$<Date=E({< Rate={"*"} >}) >} Date  ,' | ',Date)

[nivitha18]

Hi Robin,

This works, Thank you for the response.

how can we obtain these dates in a variable- Minimum date and the maximum date?

Thank you

[Anonymous]

min(distinct {$<Date=E({< Rate={"*"} >}) >} Date)

max(distinct {$<Date=E({< Rate={"*"} >}) >} Date)

???