Hi I have table named:’reporting CC Admission’ with a column called ‘DateOfAdmissionToBH’ and another table named ‘column’ with a column name ‘DateOfReferral’.
I have tried using dateddiff to calculate the number of days from referral to admission and related but cannot get the syntax right. Can anyone help please? Do I need to join the tables to create the calculated column.