AnsweredAssumed Answered

Script step for Last (Payment Date) doesnt work.

Question asked by janslort on May 28, 2013
Latest reply on May 29, 2013 by philmodjunk

Title

Script step for Last (Payment Date) doesnt work.

Post

     Im using FMP Adv11 on a PC runnin Windows.  I have a file in which I have four payment choices Pd Date1 through Pd Date4 set up as text fields.  I need to know the lastest payment Date so I did a nested If Statement:  If(GetAsText(Pd Date1) > " " and GetAsText(Pd Date2) ="" ; Pd Date 1;  If(Pd Date1) > " " and GetAsText(Pd Date2>" " and GetAsText(Pd Date 3=""; Pd Date2; If(GetAsText(Pd Date1>" " and GetAsText(Pd Date2 >" " and Get asText(Pd Date3>" " and GetAsText(Pd Date4="";Pd Date 3; If(GetAsText(Pd Date1>" " and GetAsText(Pd Date2>" " and GetAsText(Pd Date 3>" " and GetAsText(Pd Date4>" ";Pd Date4))))

     It works for two dates, 3 dates and 4 dates filled in, but NOT for only 1 date, so, you eagle eyed smart guys, what's wrong

     Jan

PdDateLast.GIF

Outcomes