start_date_time as a date, filtering a datetime

[knightyboy]

Just wondering why, when I set a variable for the start date for a Date&Time-based Row Filter, if the start date I set doesn’t include a time, but the row I am filtering does, it seems to not include the date of the start date?

e.g.

Start Date variable set as 01/10/2020

Data in the format 06/09/2020 12:04:45

the value of 01/10/2020 00:00:00 does NOT appear in the filtered result

I guess I should set a time as 00:00:00 but that’s a bit of a hassle.

what value should I be using for the start_inclusive variable?

Many thanks,
Charlie

[Matt_D]

Hi @knightyboy,

The start_inclusive variable needs to be a boolean as indicated by the icon next to the variable -

I cannot find anywhere this is documented though! Hope this helps.

Matt

[ipazin]

Hello @knightyboy,

to my knowledge if you only set start as date and without time the configuration time from node is taken. So either extend variable to be yyyy-mm-ddT00:00 or in node configuration set time to 00:00:00.

Br,
Ivan