Filter not working

[rams143]

There is field in database, its data type is Timestamp with Timezone
and I pulling it into FM and change the format to just display timestamp without Timezone
but when I am using that in the query studio the filter is not working on that field
any thoughts? :-\

Thanks,
Rams.

[blom0344]

Applying a filter does not reference the format. If you want to filter on the date (without time component) then cast the timestamp to a real date

[rams143]

Thanks Blom. That worked.