nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem filtering Date

fmakwsi

Hey guys i am trying to implement a date filter and some how it wonÂ´t work at all. i am try to set a filter like row["Date"] between Date1 and Date2 the format of the "Dates" is yyyy-MM-dd

after an tutorial i found it actually should work, but well it doesnt

Find more posts tagged with

Comments

fmakwsi

converted the input to milliseconds, doesnt change anything

fmakwsi

Someone can help? Dunno how to go on.. seems like the "Between operation" from the filter options is for Integers only

SyN

Hey, have you tried splitting your "between"-Filter into something like (row["DATE"] greater than x AND row["DATE"] less than y) ?

fmakwsi

not yet because i thought it might work with that between op and i made a mistake somewhere. but well no

but will try it now

fmakwsi

Tryiing it now with a conditional table filter, because i am able to convert the data there. wanna work with the date in ms

SyN

Alternatively, you could set the filter in your data query. Although that seems to be rather quick and dirty...

SyN

Do you have an example on this? I just tried and my filter worked with the BETWEEN option.

fmakwsi

Na gonna redo it again. just heard of a mate that he needs the data in "Date" format for inquery usage. Problably would be like between(row["Date"], params["StartDate"], params["EndDate"]) one time i had implemented this filter it just showed no data dunno why all 3 variables were in Date format

fmakwsi

works now.. was a problem with database/filter the calendar filter returned the month as int from 0 to 11 and the database returned 1-12

little difference big trouble^^