Options

how to extract only current month data

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
Hello,

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?

Answers

  • Options
    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.
    Best,
    Harshit
Sign In or Register to comment.