0 Replies Latest reply on Apr 20, 2012 3:07 AM by sushmakoyi1

    Ambiguous Function Call (to_date unknown),5 possible resolutions

      Hi,

       

      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,

      Sushma.K