Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I display date in 1,3,6,9,12,15,18,21,24,27 format.Only I want to display until 27 months.
Thanks in advance.
I think we need more information, are you asking for the difference in months?
This might be a good thread for you:
hi stacey,
please be more specific of your requirement.
so can help
Regards
Neetha
are you asking about building a list of dates that show the 1st, 3rd, 6th, 9th, 18th, 21st, 24th and, 27th of each month?
please clarify/confirm
Hello,Sorry abt that.
I have a date field called 'validityDate' which displays Date values . Date format is 30-Nov-2014.'
So now I want to group this dates into 1,3,6,9,12,15,18 format.If its 30 days from today then 1 month,if its 90 days from today then 3 months so on until if its 540 days from today then 18months .So in a list box i want to display
1 month
3 months
6 months
9 months
12 months
15 months
18 months as filter.
Hello,Sry abt that.
I have a date field called 'validityDate' which displays Date values . Date format is 30-Nov-2014.'
So now I want to group this dates into 1,3,6,9,12,15,18 format.If its 30 days from today then 1 month,if its 90 days from today then 3 months so on until if its 540 days from today then 18months .So in a list box i want to display
1 month
3 months
6 months
9 months
12 months
15 months
18 months as filter.
Hello,sry
I have a date field called 'validityDate' which displays Date values . Date format is 30-Nov-2014.'
So now I want to group this dates into 1,3,6,9,12,15,18 format.If its 30 days from today then 1 month,if its 90 days from today then 3 months so on until if its 540 days from today then 18months .So in a list box i want to display
1 month
3 months
6 months
9 months
12 months
15 months
18 months as filter.
Please see attached file, this was take from Rob Wunderlich
Search Recipes | Qlikview Cookbook
In the link Check Date-Grouping
I just made some few adjustments for you
Regards