Popdock can filter on many field types from various data sources. Datetime fields, however, take one extra step to filter precisely. The Equals criterion rarely matches a datetime field, because the full value is hard to reproduce exactly. Popdock does not have a native datetime field type, so it shows either the date or the time, but not both, so an exact match is hard to achieve on the raw field. This article explains how to extract the date value from the datetime field so you can apply precise filters in Popdock.
To watch the accompanying video, see below or click here.
Extracting the Date Value
Extracting the date value has three parts: the day, the month, and the year. Each piece is its own calculated field. Here is how to create each one:
1. From the main menu, select Connectors.
2. Edit your connector.
3. Select Lists and then edit the list with the datetime field.
4. Select Fields and then select Calculated fields.
5. Select Add calculated field.
6. For the Day calculated field, enter Day for the Name and set the Field type to Number. Set the Field language to Popdock Script. You can leave the Script field blank for now.
7. Select Add.
8. Select Add function.
9. In the Category dropdown, select Date.
10. In the Function dropdown, select Day.
11. In the Date field, change the type to Field. Then select your datetime field.
12. Select Add.
13. The Field settings should look like this:
14. Select your list in the breadcrumb. Then follow Steps 4-9 to create another calculated field for Month, entering Month for the Name in Step 6.
15. In the Function dropdown, select Month. Then, in the Date field, change the type to Field and select your datetime field.
16. Select Add. Your calculated field should look like this:
17. Following the same steps as before, you will create a third calculated field for Year, entering Year for the Name.
18. In the Function dropdown, select Year. Then, in the Date field, change the type to Field and select your datetime field.
19. Select Add. The calculated field should look like this:
Combining the Pieces into a Single Date Field
After you have extracted the individual pieces of the date, combine them into a single field with a field type of Date.
1. Select Fields and then select Calculated fields.
2. Select Add calculated field.
3. For the Date calculated field, enter Date for the Name and set the Field type to Date. Set the Field language to Popdock Script. You can leave the Script field blank for now.
4. Select Add.
5. Select Add function.
6. In the Category dropdown, select Date.
7. In the Function dropdown, select Date.
8. Change the type to Field for each of the three inputs.
9. Select the Day, Month, and Year calculated fields you created.
10. Select Add.
11. The Field settings should look like this:
Popdock then combines them into a complete date that can be filtered without the restrictions of a datetime field.
If the field does not validate on the first attempt, you can resolve it quickly: back out of the calculated field, reopen it, refresh the browser page, and then run the validation test, which should now pass.
If you have any questions about creating the filter, please reach out to support@eonesolutions.com. Our team will be happy to assist.
