Problem with date(Two Weeks) field in a group

[#1]

Hi All

'Two Weeks' in the group field works fine only when we don't select any dates field. But when I select any date field(Year: 2010) it is showing the repeatation of the date field.

Can some one please help me out this. It is little urgent!

[deepakk]

hi Attitude,

I am back..

use the code below

=date(trim(if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)),'dd/mm/yyyy')

[#3]

Deepak Kurup wrote:
I am back.. 
use the code below
=date(trim(if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)),'dd/mm/yyyy')<div></div>

Looks like you are back but I am out

This solution has done the trick! Many thanks to you... I was just wondering why you were using trim? Was there was any space in the values? I thought reason may becuase we aren't passing the year field in the below condition. Got little surprised with the solution that you had given.

Please do reply on this...

 =if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)

[deepakk]

hi Attitude,

Since you are pulling data from excel there possibilities of spaces in data , and when i saw ur data for 2010 i felt the data was coming in text format and qlikview was not able to identify as date.

Hence i tried out trim then convert it into date.