Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to compare 2 dates and get the result
User will enter the Date1 : 02/05/2018
EntryDate | DueDate | Name |
01/05/18 | 02/03/18 | aaaaa |
01/06/18 | 02/06/18 | bbbb |
01/15/18 | 05/20/18 | cccc |
01/30/18 | 06/06/18 | ddddd |
02/02/18 | 08/07/18 | eeee |
02/04/18 | 06/22/18 | fffff |
03/06/18 | 05/02/18 | dsesd |
05/06/18 | 09/09/18 | mmmm |
05/23/18 | 01/04/19 | rrrrrr |
06/22/18 | 04/04/19 | ttttttt |
06/25/18 | 09/09/20 | ssssss |
I have to find which name belongs to this below condition if the user enter the Date1 : 02/05/2018
Entry Date <= Date 1 |
Due Date >= Date 1 |
what is the best way to handle.I tried with Getfield selection for capturing the user entry and compare the values .It didn't work.
Advance Thanks for your help.
Hi Ananda,
I am not sure of capability that user can enter data.
alternative will be in your script create a table(calendar) that has all the dates. Use a filter in front end give user a capability to enter or search date in there. make sure your Date column name in calendar table matches with your EntryDate.
Then Your KPI expression would be
if(GetCurrentSelections(EntryDate1)>=EntryDate1 and GetCurrentSelections(EntryDate1)<=DueDate1,Name,0)
may be it helps.
Assume it is Sense, assume Date1 is a variable, press shift + drag your user field to the sheet, then edit the field to:
=if([EntryDate]<='$(Date1)' and [Due Date]>='$(Date1)',
YourUserField
)
Fei
Enter Means, From Input or Selection in the field?