🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

how to identify the period is complete or not

sgnarkhede2016User: "sgnarkhede2016"
New Altair Community Member
Updated by Jocelyn
Hello,
If the period will be start or end with the middle then exclude that period
i.e Data Available from 15May2020 up to 29Nov2022 then exclude May and Nov month data

lll'y For Quarter,Half-Year,Year how to do this.

Thanks,
Sachin N

Find more posts tagged with

Sort by:
1 - 1 of 11
    BalazsBaranyRMUser: "BalazsBaranyRM"
    New Altair Community Member
    Accepted Answer
    Hi!

    You could try to extract the year-month part of the date and generate a simple table with year-month and the number of days therein. You should be able to do that easily in a spreadsheet application Then join on the month, use Aggregate to count the days and if the number of days is less than the number of days in that month, remove the data.

    Regards,
    Balázs