Skip to main content
Question

How to filter datetime field by only date?


Forum|alt.badge.img+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

Forum|alt.badge.img+4
  • Do Gooder (Employee)
  • 17 replies
  • January 22, 2024

You can use tags like

 

Thanks

Sumit Joshi


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • 1132 replies
  • January 22, 2024

Hi @Miraj 

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

I wish you all the best 😎

Cheers!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings