Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
In my model i have periods for two years (2014, 2015) with every dates.
For example, last date in my model is 30.11.2015
I need to make some flag in load script, which will reduce on closed month:
0 - all periods (01.01.2014 - 30.11.2015)
1 - all period without not closed month (Nov 2015) (01.01.2014 - 31.10.2015)
Please, help.
Not closed month means like this 01.12.2014 - 23.12.2-014?
Try like:
Load
Date,
If(InMonth(Date, Today(), 0), 1, 0) as Flag
Hi Andrey,
As of my understanding, you need to create the two flags as 0,1 and this should be
Closed month- As month ends with even number like 30-11-2015
Unclosed month -As the month ends with the odd number like 31-10-2015.
If my understand is wrong can you please elaborate your question.
Thanks
Kumar
Hi!
In your solution:
0: 01.01.2014 - 31.10.2015. I need - 01.01.2014 - 30.11.2015
1: 01.11.2015 - 30.11.2015. I need - 01.01.2014 - 31.10.2015
Thanks.
01.01.2014 - 31.10.2015 - is common to both flags? You can't flag one date with two flags.