Which date comes later

[gfisch13]

Hi - I have a policy master file that has three dates, an issue date, a lapse date and a new issue date.   I want to be able to identify any policies that we wrote after the LapseDate.  I was thinking of doing this with a list box, but creating an indicator to use in a field I add to the table would work too, I'm not certain on how to pull this off. 

I tried a variation of NewIssueDate>=LapseDate as an expression for a list box, but it didn't seem to calc properly.

Ex.....

IssueDate	LapseDate	NewIssueDate	Ind
01/01/2016	09/01/2016		N
03/05/2016			N
05/01/2016	06/01/2016	09/01/2016	Y
05/02/2016	06/30/2016	07/10/2016	Y

Any help is appreciated!

George

[sunny_talwar · Accepted solution]

May be this

If(If(Len(Trim(NewIssueDate)) = 0, 0, NewIssueDate) >= If(Len(Trim(LapseDate)) = 0, 1, LapseDate), 'N', 'Y') as Ind

This will create your flag... not sure what do you want to see in the list box? The flag or something else?

[gfisch13]

I would like to the the flag in the list box, so the Y and N.

[sunny_talwar]

So, once you create the above in the script... you should be able to use Ind as your list box

[gfisch13]

Can this expression be used to setup the listbox or is it better to load it in the script and be a part of the table object first?

[sunny_talwar]

I would suggest doing this in the load script as it avoids unnecessary complexities on the front end of your application.... if you still want this to be on the front end... you can try this as your list box expression

If(If(Len(Trim(NewIssueDate)) = 0, 0, NewIssueDate) >= If(Len(Trim(LapseDate)) = 0, 1, LapseDate), 'N', 'Y')

[gfisch13]

Really appreciate your input, as always!!!