topic Problems with dates in QlikView

Problems with dates

Thu, 07 May 2009 14:19:55 GMT

Hi,

I've a little problem with dates.

I've a 'Date' field that contains all the possible dates within the active date range, the problem is to compare this field with two more fields on the application to obtain a resultant IF clause that defines for example if a employee is contracted on this date range depending on his contract starting date and his contract finishing date...

I' hope i've explained it correctly,

Thank you,

Sam1980

Problems with dates

manishkumar75 — Thu, 07 May 2009 15:10:22 GMT

Hi Sam,

Have you tried comparing date with providing the format :

if ( date(DateColumn,'MM/DD/YYYY') > date([Contract Starting Date],'MM/DD/YYYY'),'Expression' ,'Else Expression')

- Manish

Problems with dates

Thu, 07 May 2009 16:09:16 GMT

Yes,

I've tried this but it doesn't work properly, I think that the main problem is that we're selecting one month and then Qkv tries to compare a group of dates (all the month days) with one single date and that's obiusly not correct...

Don't you have any suggestions about that?

Thanks

sam

Problems with dates

Thu, 07 May 2009 16:17:21 GMT

Hi Sam,

Try it out with sample file attached. i have used calendar object to select the dates.

Thanks

Saran.

Problems with dates

Oleg_Troyansky — Thu, 07 May 2009 21:34:41 GMT

Sam,

I'm not sure I understand your problem... A sample could help...

You might be better off linking the dates in the data structure, using INTERVALMATCH, rather than messing with IF formulas.

Oleg