AnsweredAssumed Answered

CALCULATION help with the LAST Function

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

Title

CALCULATION help with the LAST Function

Post

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.

IE.

              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.

Outcomes