Iterno() working with while

    Hello Friends,

     

    I publish here a simple examples how Iterno( ) function works with the While function to make dates between two ranges with using differently. Iterno( ) function returns integer 1 and it is work with while function until the condition is not satisfy and normally this function used in the master calendar for date creation. Where we want to create a date between any range like we say from any date to any end date. Here i explain i have two dates FromDate and Todate and this dates are used as Num dates because Iterno( ) works on the num dates.This is very basic example with explanation of the Iterno( )

     

    Suppose the dates

     

    FromDate = 01/04/2014

    ToDate = 10/04/2014

     

    1. While IterNo( ) <= ToDate - FromDate +1

    and we convert this dates FromDate  and ToDate into number by Num function

    Num(FromDate) = 41730

    Num(ToDate) = 41739

     

    so if we see While statement and put values and at initial iterno( ) start from 1

    While IterNo( ) <= ToDate - FromDate +1

    While IterNo( ) <= 41739 - 41730 +1

    then equation will be

    While IterNo( ) <= 10

    Means while loop runs 10 times until IterNo( ) <= 10 while this loop runs our dates are created by adding 1 to value 41730 like 41731,41732......41740 and this are in num then we convert this dates into date by Date(Num(FromDate)).

    Here we get date from 01/04/2014 to 10/04/2014

     

    2.While IterNo( ) <= ToDate - FromDate -1

    if we see equation here for while condition with the dates

    Num(FromDate) = 41730

    Num(ToDate) = 41739

    Then,

    While IterNo( ) <= ToDate - FromDate -1

    While IterNo( ) <= 41739 - 41730 - 1

    then equation is

    While IterNo( ) <= 8

    Means in this while condition loop runs 8 times and we are get 8 date values only

    Here we get dates from 01/04/2014 to 08/04/2014

     

    3.Date($(vDateMin) + RowNo( ) -1) AS TempDate

    for this dates suppose Date($(vDateMin) is 01/04/2014

    then we get the values for equation like

     

    Date($(vDateMin) + RowNo() -1)

    For first record

    vDateMin + 1 - 1  = 41731

    For Second record

    vDateMin + 2 -1 = 41732

     

    and so on until loop satisfy the condition then it will stop and a field is obtain named TempDate which contain date format and date from 01/04/2014 to 08/04/2014.

     

    Regards