Creation of a formula invoving blanks

[#1]

Hi

I have created a (straight table on the front end) which is shown below.

I am struggling  to get the comment part right.

My formula should read as follows

If the "Delvery Date" is greater than the "Expected Delivery Date",than the result should be "Late Delivery" , if not it should be "On Time".

If the "Delivery Date" is blank, than the result should be blank, however i get the comment "On Time".  This is incorrect (ie On Time should not be the result if delivery date is blank)

Here is my formula:

if([Delivery Date]=' ',' ',if([Delivery Date]>[Expected Delivery Date],'Late Delivery','On Time'))

Thank you

kind regards

Nayan

Invoice Number	Order Date	Invoice Date	Expected Delivery Date	Delivery Date	Comment
IN0000000673994	4-Mar-13	7-Mar-13	15-Mar-13	-	On Time
IN0000000674000	4-Mar-13	7-Mar-13	15-Mar-13	-	On Time
IN0000000675017	4-Mar-13	12-Mar-13	15-Mar-13	-	On Time
IN0000000675018	4-Mar-13	12-Mar-13	15-Mar-13	-	On Time
IN0000000675020	4-Mar-13	12-Mar-13	15-Mar-13	-	On Time
IN0000000675546	12-Mar-13	14-Mar-13	12-Mar-13	-	On Time
IN0000000676582	18-Mar-13	19-Mar-13	29-Mar-13	-	On Time
IN0000000676762	12-Mar-13	20-Mar-13	22-Mar-13	-	On Time
IN0000000676763	12-Mar-13	20-Mar-13	22-Mar-13	-	On Time
IN0000000677076	12-Mar-13	22-Mar-13	12-Mar-13	-	On Time
IN0000000677760	18-Mar-13	27-Mar-13	29-Mar-13	-	On Time
IN0000000694083	19-Jun-13	20-Jun-13	25-Jun-13	27-Jun-13	Late Delivery
IN0000000695530	26-Jun-13	27-Jun-13	26-Jun-13	28-Jun-13	Late Delivery
IN0000000695552	26-Jun-13	27-Jun-13	26-Jun-13	27-Jun-13	Late Delivery
IN0000000695669	20-Jun-13	27-Jun-13	25-Jun-13	2-Jul-13	Late Delivery
IN0000000695727	20-Jun-13	28-Jun-13	25-Jun-13	2-Jul-13	Late Delivery
IN0000000696044	1-Jul-13	1-Jul-13	5-Jul-13	2-Jul-13	On Time
IN0000000696103	1-Jul-13	1-Jul-13	5-Jul-13	2-Jul-13	On Time
IN0000000696107	1-Jul-13	1-Jul-13	5-Jul-13	2-Jul-13	On Time
IN0000000697810	8-Jul-13	10-Jul-13	15-Jul-13	17-Jun-13	On Time
IN0000000699376	17-Jul-13	17-Jul-13	30-Jul-13	24-Jun-13	On Time
IN0000000703120	1-Aug-13	2-Aug-13	5-Aug-13	7-Jun-13	On Time
IN0000000703823	5-Aug-13	6-Aug-13	8-Aug-13	8-Jun-13	On Time

[tresesco]

Try this:

if(Len(Trim([Delivery Date]))=0,' ',if([Delivery Date]>[Expected Delivery Date],'Late Delivery','On Time'))

For better understanding have a look here

[rajeshvaswani77 · Accepted solution]

Try this:

if(isnull([Delivery Date]),' ',if([Delivery Date]>[Expected Delivery Date],'Late Delivery','On Time'))

thanks,

Rajesh Vaswani

[#4]

Hi Rajesh

It worked . Thank you.

Kind regards

Nayan

[#5]

Hi Tresesco

Your formula worked too.

Thank you

Kind regards

Nayan