Forum Discussion
Getting all dates between 2 dates
Hi,
I have a similar situation, where I wanted to get the list of dates between 2 dates. It worked perfectly..Except the the values corresponding to those list of dates are summed together.
May be its the use of 'Number' in ,
{ Number.From([StartDate])..Number.From([EndDate]) }
Is there a way to produce the same result but the values remain intact.
P.S I did use Day/Date, { Date.From([StartDate])..Date.From([EndDate]) }
It didnt worked for me & gave error
"Expression.Error: We cannot apply field access to the type Function.
Details:
Value=Function
Key=LabEntryDate"
Any help will be greatly appreciated
Thank you.
In order to help you I need the full query code - could you pls post that here?
- Anonymous6 years agoNot applicable
Hi,
I want to reproduce the same code but instead of days I need the amount of months between two dates.
Is that possible?
- Ashish_Mathur6 years agoSuper User
Hi,
Share some data and show the expected result.