title: How does the _first_of_month (current_date) Cognos function work?
body: <p>How does the _first_of_month (current_date) Cognos function work?</p>
  
  <p>If the current date today is September 8, does it return all the value from September 1 to September 8? Month to date. Or does is return the value of the past month? Does it only return a value of 1 day?</p>
  
  <p>So if I have a column CreatedDate then I use the function like this.</p>
  
  <p>[CreatedDate]=_first_of_month (current_date)</p>
  
  <p>This is an example of the CreatedDate column.</p>
  
  <p><a href="https://i.stack.imgur.com/Upc3G.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Upc3G.png" alt="enter image description here"></a></p>