1 Reply Latest reply: May 15, 2014 10:13 AM by Chickenman _ RSS

    previous month data range

    joe.lovati _

      I guess this is more of a observation than it is a problem, but I have models that filter dates from the previous month on a floating basis,

       

      So, start of last month to end of last month.    There is a End of Previous month feature but no Start of Previous month function. 

       

      I did get this to work by using the following to id the start of last month. 

       

      Start_Of_Current_Month(End_Of_Previous_Month())

       

       

      Here is the entire filter logic

       

      >=Start_Of_Current_Month(End_Of_Previous_Month()) .And. <=End_Of_Previous_Month()