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
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.
@N8AKTIV, spot on. If you take the TimeDim() approach your formula would look like this…
=TimeDim([Financial Trans Date])
With this result…
Works perfect, I thank you both!