Need data from start date of the year till today

Follow

Shasanka Erukulla

• June 22, 2016 17:55

All I have is datecolumn, year, month  (integers) I need to extract the data year till date i.e. 1/1/2016 till today

0

• 

  Joel Stewart

  • June 22, 2016 17:59

  I'd recommend combining the Datecolumn, year and month integers into a DATE type column using the ASDATE function into a new column. Then you can create a Filter to select all dates after January 1, 2016.

   

  0

  Comment actions Permalink
• 

  Pablo Redondo

  • June 22, 2016 18:11

  I recommend using the date functions, but you can also filter on the year column. Set year column equals year(today()). Select as input a "Formula" instead of a "constant" (See below).

  
  
  

  0

  Comment actions Permalink

Please sign in to leave a comment.