This discussion is archived
3 Replies Latest reply: Mar 17, 2013 10:29 PM by Amatu Allah RSS

select all the dates between two txt fields. how?

875255 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points