topic if(Date(floor in QlikView

if(Date(floor

carolin01 — Fri, 14 Nov 2014 11:28:54 GMT

Hi,

Could anybody tell me what´s wrong with this function in my script load:

If(Date(Floor( PlannedDeliveryDate) = '20.10.2020', 'Blanket Order', 'Order')) as Type,

I do not see the error...

Many thanks!!!

Carolin

Gysbert_Wassenaar — Fri, 14 Nov 2014 11:37:48 GMT

Try: if(Date(Floor(PlannedDeliveryDate)) = '20.10.2020', 'Blanket Order', 'Order') as Type,

sushil353 — Fri, 14 Nov 2014 11:46:08 GMT

Hi,

try below one:

if(DAte(Floor(PlannedDeliveryDate),'DD.MM.YYYY')='20.10.2020','Blanket Order','Order') as Type

HTH

sushil

MarcoWedel — Fri, 14 Nov 2014 11:57:19 GMT

Hi,

bracket at wrong position:

If(Date(Floor( PlannedDeliveryDate)) = '20.10.2020', 'Blanket Order', 'Order') as Type,

hope this helps

regards

MArco

carolin01 — Fri, 14 Nov 2014 12:10:06 GMT

So simple sometimes - Thank you