how to extract only current month data

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II

how to extract only current week/month/quarter data from dataset
e.g In this month current date is 13thAug2020, I want to extract only these 13days data from dataset.
How can i do it?


  • hbajpaihbajpai Member Posts: 102 Unicorn
    Hey @sgnarkhede2016

    You can use date_get() function in generate attributes operator to fetch Day, Week and Month from a Date attribute. You can use a simple if-else to generate the quarter from month thereon.
Sign In or Register to comment.