Date comparision based on User Entry

[anandaqv]

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.

[afroz_shaik]

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.

[NZFei]

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

[Anil_Babu_Samineni]

Enter Means, From Input or Selection in the field?