Question

How to filter datetime field by only date?

  • 22 January 2024
  • 2 replies
  • 77 views

Userlevel 4
Badge +9
  • Sidekick (Partner)
  • 59 replies

Hi Experts,

We need to filter the tasks by the plan_start_dttm and by only using the date part. This field is a datetime field with a mask type of datetime. Now the problem is we are not able to do that easily,


ex: 
 


On the web client,
 

Nothing gets fetched since it’s trying to match the exact time as well.

One way to do this is to have an expression,
 


But this is clearly not user friendly.

Another option would be to use a view and create a field that filters only with the date, and set this view field against the search section of the screen. But this is extra work.

Is there any easy solution for this?
(Let’s assume that changing the field mask on the metadata level to “dateonly” is not an option)


2 replies

Userlevel 1
Badge +4

You can use tags like

 

Thanks

Sumit Joshi

Userlevel 6
Badge +26

Hi @Miraj 

I think you are aware of the challenges and the solutions.

I wish you all the best 😎

Cheers!

Reply