I have 2 fields : planned date (First Pick Plan Date Start) and an actual date (First Pick Arrival Date).
First Pick Plan Date Start
First Pick Arrival Date
18/01/2016 06:58
18/01/2016 16:04
18/01/2016 11:54
18/01/2016 08:47
18/01/2016 16:50
18/01/2016 22:10
18/01/2016 21:46
20/01/2016 01:25
User will select planned date i.e. (First Pick Plan Date Start) on the selections.
When user selects (First Pick Plan Date Start) for example 18/01/2016, l want to create a variable that help me to show all loads with a (First Pick Arrival Date) that is the same with one on current selection (First Pick Plan Date Start) i.e. 18/01/2016.
When user selects (First Pick Plan Date Start) for example 18/01/2016, l want to create a variable that help me to show all loads with a (First Pick Arrival Date) that is the same with one on current selection (First Pick Plan Date Start) i.e. 18/01/2016.
Not really sure what the variable will sow when you select 18/01/2016. Can you elaborate on your desired result?
As Sunny has suggested some more information would be helpful.
From the limited information we have, i would think that you could achieve this without a variable.
If in script you strip just the date values from the First Pick Plan Date Start field and use this a selection it would show all associated First Pick Arrival Date.
