Admin,
I have a child table that relates to Personnel named R&R.
The table is as such:
leave_type: VARCHAR
leave_date: DATE
Back_2_work_date: DATE
rr_duration: back_2_work_date - leave_date = rr_duration
I am trying to use the lookup wizard to retrieve the total days of the user going on vacation. His vacation duration would be calculated by back_2_work_date - leave_date = rr_duration.
I put the following in the Lookup Wizard's default value for rr_duration:
CONCAT(datediff("back_2_work_date", "leave_date"),' ', "Days")
Now, I am getting a nice error when trying to run the page. What am I doing wrong?