2 Replies Latest reply: Jan 11, 2013 8:18 AM by Aderlan Rodrigues RSS

    problemas com Data

    Leonardo Osorio

           Declaro uma Variavel

      Let sAnoMesProc = mid(AddMonths(today(),-1),7,4)& '/' &mid(AddMonths(today(),-1),4,2);

       

       

      Mas na hora de comparar no where, nao compara. Não consegui entender o pq..

      Load

      QT_KM ,

      VL_DESPESA_DESP,

      if(IsNull(ID_USUARIO_DESP),'',ID_USUARIO_DESP) & if(IsNull(ID_CONTRATANTE_DESP),'',ID_CONTRATANTE_DESP) & if(IsNull(ID_CC_DESP),'',ID_CC_DESP) AS SK_DESPESA

      Resident FATO_DESPESAS

      Where DATE(DATA_DESP,'YYYY/MM') =  $(sAnoMesProc);