I have a date field,which has only business day dates.It has more than 200 dates exclusive of non business dates.
I would like to get previous business date ,after writing logic,runtime this error throwing out.
The logic which i have used for previous business date is as follows :
IF(MAX(DATE(DBDateField))<DATE(ParameterDate)) THEN number of records END
Since the requirement is in such a way that two subsequent business dates to be shown in same work sheet.
Thanks & Regards,
Retrieving data ...