Variables

[#1]

Hi All;

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.

Please assist.

Regards;

Moses

[sunny_talwar]

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?

[Mark_Little]

Hi,

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.

Mark

[asgardd2]

Please see the attached example and explain, that you want  to show, through new variable.