Hi Niall,Thank you for your reply. I'm still a bit puzzled as right now
I have this code in my calculate field (see below) under the calculated
event and I'm not sure how to insert the code you sent me as I keep
getting syntax errors. Any help will be greatly appreciated!!!if
(HasValue(Nights.FirstNight) & HasValue(Nights.LastNight) ) then if
(Date2Num(Nights.LastNight, "YYYY-MM-DD", "en_IE") >=
Date2Num(Nights.FirstNight, "YYYY-MM-DD", "en_IE")) then $ =
Date2Num(Nights.LastNight, "YYYY-MM-DD",...