4 Replies Latest reply on Apr 3, 2012 10:42 AM by JCPython

    Gathering Date Fields From a Range

    JCPython

      Title

      Gathering Date Fields From a Range

      Post

      I have a table with a date field called (cEstHatchDate), this is a calculation of another date field with a number field were the value in the number field is added to the date in the date field to give the cEstHatchDate result as a date.

      I want to create a find to show only records with cEstHatchDate field value beeing equal to today date or any of the "7" days before hand. so its a week range im trying to get to show for these records, i tried a few things but im still learning the find and perform features and i been strugeling here, all i can bet on is that it involves a calculation of some sort, but thats all i can figure out. can anyone help point me in the right dirrection?