if(Date(floor

[carolin01]

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 · Accepted solution]

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

[sushil353]

Hi,

try below one:

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

HTH

sushil

[MarcoWedel]

Hi,

bracket at wrong position:

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

hope this helps

regards

MArco

[carolin01]

So simple sometimes - Thank you