There is one date field which is Canonical date in pivot table.

[KommulaRahul]

I have taken two variables vstartDate and vEndDate. I need to get the dates from starting date of this month (Jun 1) to today's date. 

I used valueloop($(vstartDate), $(vEndDate)) . But I'm getting the dates in serial number(45078) format. 

How to convert these numbers into date format like (45078 to 01-06-2023) 

[hic]

Try

 Date(ValueLoop($(vstartDate), $(vEndDate)))

[KommulaRahul]

I tried this but it's not working.