FIND THE DAY OF THE WEEK FOR A GIVEN DATE
--------------------------------------------------------------------------------

@CALCTEXT(
	if(mod(datediff('12-31-1899', [appt_date], 'd'),7)=0, 'SUNDAY',
	if(mod(datediff('12-31-1899', [appt_date], 'd'),7)=1, 'MONDAY',
	if(mod(datediff('12-31-1899', [appt_date], 'd'),7)=2, 'TUESDAY',
	if(mod(datediff('12-31-1899', [appt_date], 'd'),7)=3, 'WEDNESDAY',
	if(mod(datediff('12-31-1899', [appt_date], 'd'),7)=4, 'THURSDAY',
	if(mod(datediff('12-31-1899', [appt_date], 'd'),7)=5, 'FRIDAY',
	if(mod(datediff('12-31-1899', [appt_date], 'd'),7)=6, 'SATURDAY',''
))))))))

--------------------------------------------------------------------------------
DISPLAY TIME AS A 12-HOUR CLOCK (MUST ACCOUNT FOR 12:00 AM/PM)
--------------------------------------------------------------------------------

@CALCTEXT(
if([appt_time]<>'' and left([appt_time],2) = 0,
    concat("12:",right([appt_time],2)," AM"),
    
if([appt_time]<>'' and left([appt_time],2) > 0 and left([appt_time],2) < 12, 
    concat(mod(left([appt_time],2),12),":",right([appt_time],2)," AM"),

if([appt_time]<>'' and left([appt_time],2) = 12,
    concat("12:",right([appt_time],2)," PM"),
    
if([appt_time]<>'' and left([appt_time],2) > 12, 
    concat(mod(left([appt_time],2),12),":",right([appt_time],2)," PM"),
'')))))