Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Colleagues, good day!
Is in QV any solution to make field with two moth periods, in which every month includes two periods?
I need to make field (by date field) with such values:
Jan-Feb
Feb-Mar
Mar-Apr
Apr-May
May-Jun
Jun-Jul
Jul-Aug
Aug-Sep
Sep-Oct
Oct-Dec
Dec-Jan
Many thanks for every advice!
Andrey.
Have you got date field?
Create something like below..
Dual(Month(Date) & '-' & Month(AddMonths(Date,1)) ,Month(Date)) as YourDualMonthField
Is this This Month - Next Month or Last Month - This Month?
Yes. I have date field.
Field YourDualMonthField , example (Jan-Feb) get only January dates, but i need Jan & Feb dates
Thanks.
yes
Which one of the two?
ThisMonth - NextMonth
or
LastMonth - NextMonth?
It must be not flag, but field with two month period names.
For example, today date (09.02.2016) must include Jan-Feb and Feb-Mar.
Something like below?
Data:
Load * Inline
[
Date, Sales
10/01/2016, 100
25/02/2016, 120
12/03/2016, 90
];
DualMonth:
Load Distinct Date, Month(Date) & '-' &Month(AddMonths(Date,1)) as Flag Resident Data;
Concatenate
Load Distinct Date, Month(AddMonths(Date,-1)) & '-' &Month(Date) as Flag Resident Data;
It doesn't work.
Your dates are text values, not proper date values. Convert them to proper numeric date values and then Manish's logic will work.
When you load the dates, you need something like:
LOAD
...
Date#(Date, 'dd/MM/yyyy') As Date,
...