Field not found during script loading

[Vince_CH]

Dear Friends,

I encountered an issue today, that during script loading it appeared the field of "Date" cannot be found. actually it was there as below yellow marked. also it was no problem when i run the same script in earlier days.  what could be problems and causes? thanks for the help in advance. 

[Anil_Babu_Samineni]

Can you try to load one more time from scratch and see If Prod.Order_Start_Date field is available or not.

[mikaelsc]

check "where" clause? (not visible on your screenshot)

[asinha1991]

check if you put ";" semicolon after every load or any other statement written previously

[Vegar]

You can not refer to the field Date anywhere in the load statement, you have to refer to the Prod.Order start_date. This includes the whole LOAD and WHERE part of the query.

[Vince_CH]

Gents, thanks, I checked, bug was from the source data that one more row as added on the top of headline, so the field can not be found during loading. thanks very much for the support.

[Sameer9585]

try this?

Date(Prod.Order_Start_Date,'MM/DD/YYYY') as Date