Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nivitha18
Partner - Contributor
Partner - Contributor

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

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable

try

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

View solution in original post

3 Replies
Anonymous
Not applicable

try

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

nivitha18
Partner - Contributor
Partner - Contributor
Author

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
Not applicable

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

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

???