Hello Everyone,
As I Am filtering the data using date filter result is coming as below
here i can include the $start date $end date parameters
And as filtering data using the calculated field like
aggregation and
Date >= $start date and Date <=$end date
for those 2 cases it shows different results,
why this is happening and i want to use those 2 methods
i want to include start and end dates in calculated field.
Best ,
Vaibhav
@Vaibhav.narwade what start and end date did you used? looks like only the end date is excluded? Is it possible its a date time issue of the date field?
Hi @ErikG,
I have used the calculated filed but I don’t know how this is excluding the end date I took date diff also it shows correct but don’t know why this is not working.
Best,
Vaibhav
Did you the datediff with days or something smaller?
Maybe you can try with hours or minutes to check if it isn’t using a timestamp
hi @ErikG,
Thank you for your response.
I used “DD”+1 for achieve this and it is working fine.
Best,
Vaibhav
