3 Replies Latest reply: Mar 18, 2013 12:29 AM by Amatu Allah Neveen Ebrahim RSS

    select all the dates between two txt fields. how?

    875255
      In a 6i form cursor I need to select all the dates between two provided dates. I have two text fields FLD1 and FLd2 with date datatype. There is no table behind both the fields.
      For example
      :FLD1:='01-MAR-2013';
      :FLD2:='10-MAR-2013';

      Now I have to select all the dates from 01-mar-2013 to '10-mar-2013'. how to do it?