Need a variable to display individual dates between a begin and end date

If I am pulling a begin date of 6/1/2021 and an end date of 6/5/2021, I need to display 6/1, 6/2, 6/3, 6/4, and 6/5. I don’t have any data on the dates in between begin and end dates but I need to display them.

Thanks in advance

you can build a second query/datasource with only list of all dates and merge that to your report
or you can use the timedim()-function to fill the missing dates.

1 Like

@N8AKTIV, spot on. If you take the TimeDim() approach your formula would look like this…

=TimeDim([Financial Trans Date])

With this result…

1 Like

Works perfect, I thank you both!