When Comparing Dates

When comparing two dates.

if (Appt_Start_Dt < ToDate(‘05/01/2008’)){‘remove’} else {‘keep’}

When determining whether a date is > or < another date.  This function ensures the field is a date field.

if (Actual_Work_Date >= ToDate(‘07/01/2005’) && Acutal_Work_Date <= ToDate(‘06/30/2006’)) {‘y’} else {‘n’}

Last updated: October 15, 2013

Last updated: October 15, 2013