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.
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.