Filtered vs Calculated Fields Value difference

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
image

image

And as filtering data using the calculated field like
aggregation and
Date >= $start date and Date <=$end date
image

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

Hi,

Please take a referrnce from Snapshot.

Best Regards,
Vaibhav Narwade

@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?

1 Like

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?

Hi @ErikG,

I have filtered with Days like “DD”.

Best,
Vaibhav

1 Like