Skip to main content
Question

How to create Sheet level date filter using a dropdown?

  • April 8, 2022
  • 1 reply
  • 4 views

I have to create a date filter (which should be a dropdown), that only filter the components in that particular sheet. I think this can be done using a sheet filter by setting a variable using a button dropdown. The problem is that the date is in DateTime format, and it writes to the variable like this : "Sun Jan 03 2016 05:30:00 GMT+0530 (India Standard Time)", I am new to pql and I don't know how to convert it into a proper format so that it can be used with FILTER statement in load script. Please help me out.

1 reply

  • Level 5
  • 11 replies
  • April 13, 2022

Hi @mohammad.nomaan.husai ,

 

Try using the below filter statement. It will work..

 

FILTER "_CEL_INC_ACTIVITIES"."_CEL_CHANGE_DATE" >= {d '2022-04-13 00:52:04' }

 

Syntax is FILTER Table.DateField Operator {d 'YYYY-MM-DD HH:MM:SS}

 

Regards,

JayB