I have a screen inside a test that I’m doing that pulls a column (column 1 of the photo) from a certain table.
I would like to do the following:
Put 2 text fields to choose a start date and an end date that are recorded in column 2 (of the image) to serve as a filter to display the items in column 1.
For example, you will need to have a date selection field (which pulls the data from column 2) for the user to choose, for example, the month they want. Once this is done, all items (from column 1) for the month he selected will be listed.
well then you need to get all data of column data, and compare that list with date tools extension, a very long method, i will try to create a guide for that
yes first of all we get all data of both tables and store them into lists, then for each item in list (dates) if date = selected date then add item to new list, item ( select list item of valor list, index ( index in list item ( get item of compared date if = select date) and then after comparing all, data will be added to new list, difficult but working method,