Custom column filter condition is not getting correct data in service now

[Aditya1204]

we have created a custom column in sn_communities_forum table. when we added filter condition for this particular custom column(date/time), we are not getting as expected correct data. (we got irrelevant/incorrect data)

[SanjivMeher]

Can you provide more information? Post some screenshots?

With the current information, it is not possible to understand what you are asking for.

[Aditya1204]

Please check the below image for clarification. we have applied the filter between 2 dates but output results are getting incorrect information. showing records which is in 2024

[Anubhav24]

Hi @Aditya1204 ,

What is the type of this column ?

I think the column should be of be date/time data type.

Please mark helpful/correct if my response helped you.

Please mark helpful/correct if my response helped you.

[Aditya1204]

the column type is  date/time data type. but column is custom that we created