AnsweredAssumed Answered

CALCULATION help with the LAST Function

Question asked by TracyBogans on Mar 31, 2011
Latest reply on Mar 31, 2011 by philmodjunk


CALCULATION help with the LAST Function


I am using the LAST function, LAST(DUE_DATE),  to get the date of last due date. But when the field is empty it pulls the date from the next record that has a date in the field.

 I want to have it show the information from the last record entered even if the date filed is empty.


              F1         F2

Record 1   test   

Record 2   test   

Record 3   test   4/1/11

 I want it to show the date that is in record 1 even if there is no date entered in the field. Instead of pulling the date the was entered in record 3.  Record 1 was the last information entered into the database.