Problems with dates

[#1]

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

[manishkumar75]

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

[#3]

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

[#4]

Hi Sam,

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

Thanks

Saran.

[Oleg_Troyansky]

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