9 Replies Latest reply: May 23, 2013 5:24 AM by Vishwaranjan Kumar RSS

    Number to Date format in where condition

    BRIJESH GADHESARIYA

      Hi all,

       

      I wanted to fetch a table from my backend and wanted to generate a qvd, but I wanted data from 1st Aprl,2013 only.
      Due to my date in backend is in number format, I am getting a script level error which is attached here.

       

      ------

      //My script for fetching data

      Load Field1,

              Field2,

              Field3

      from "dbname"."tablename" where Date >='2013-04-01';

       

      -----