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.
Page 1 / 1
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.