This content has been marked as final.
Show 4 replies
-
1. Re: How to create a group of months?
Mark FraserAug 4, 2016 12:58 AM (in response to Dilyana Suleymanova)
Hi Dilyana
You could just use an IF statement... something like (this is just for the concept...)
IF [date/time] < Apr-16 Then '12.15-03.16'
ELSE [date/time]
END
You may need to do some formatting and date manipulation using DATEPART() but should be easy enough.
Is that enough to get you started?
Happy to help further, although some example data would help.
Cheers
Mark
-
2. Re: How to create a group of months?
Mark FraserAug 4, 2016 1:06 AM (in response to Mark Fraser)
-
Book1.xlsx 8.0 KB
-
-
3. Re: How to create a group of months?
Dilyana Suleymanova Aug 4, 2016 1:36 AM (in response to Mark Fraser)It is great! Thank you Mark
Best regards from Berlin!
-
4. Re: How to create a group of months?
Mark FraserAug 4, 2016 1:45 AM (in response to Dilyana Suleymanova)
You're welcome, neighbor...!
Best regards from The Netherlands