Issue with date filteration from the UI

🖌 UX (User Experience)
#1

Hi there,

I have a field called checked_in_date which stores the date when the customer checked in.
I use the REST API to set the field and I use this format for example 2022-04-19T21:57:34+03:00
note, I’m in +3 time zone

the issue here, when I’m at the record-list page and I do this filtration

Screenshot from 2022-04-19 22-13-32
Screenshot from 2022-04-19 22-13-32966×363 90.8 KB

it should only display the records which have checked_in_date after that date and time. but in reality, it shows records before that time. see the filtration results
image

am I doing something wrong here! … if so please advice

#2

Looks to me like it should work; I’ll have someone take a look and update you

1 Like
#3

Hello @munawir,

can you, please, share your checked_in_date field settings?

#4

hey @katrinyordanova, normal DateTime field except for the Format

image
image869×437 28.6 KB

#5

@munawir , thank you for the provided screenshot. We’re looking into the issue and will update you once we know more.

1 Like
#6

@katrinyordanova @tjerman sorry to bother you :slightly_smiling_face:
any update here?

#7

No; I was having trouble in reproducing it when I wanted to fix it so I’ll have another crack at it (probably) next week with Katrin

#8

@tjerman good luck guys

I think the issue around the timezone conversion (I’m in +3 area)

#9

@munawir the issue has been fixed. Can you test and confirm it works for you too?

2 Likes
#10

@katrinyordanova which deployment version I can find the fix?
I’m currently using 2022.3.1

1 Like
#11

@munawir the fix is on 2022.3.2

1 Like