Date function.

[#1]

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.

[datagrrl]

I think we need more information, are you asking for the difference in months?

This might be a good thread for you:

How Do I Get the Number of Months Between Two Dates?

[Anonymous]

hi stacey,

please be more specific of your requirement.

so can help

Regards

Neetha

[#4]

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

[#5]

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.

[#6]

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.

[#7]

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.

[maximiliano_vel]

Please see attached file, this was take from Rob Wunderlich

rwunderlich‌

Search Recipes | Qlikview Cookbook

In the link Check Date-Grouping

I just made some few adjustments for you

Regards