using script editior

[#1]

Hi

In my script editor I want to load data only in a specific date range ie from 01/01/2010 onwards

how do I write this?

Thanks

This is my script

LOAD IncidentID,

     Region,

     Site,

     DateRaised,

     Year(DateRaised) as Year,

     Month(DateRaised) as Month,

     ReportedBy,

     NonConformanceArea,

     NonConformanceAreaCategory,

     Description,

     Priority,

     CloseOut,

     CompletionDate

[SunilChauhan · Accepted solution]

in script editor write your load like below

load

column1,

column2

.....

from path where DateRaised>='01/01/2010'

[erichshiino]

if you have some trouble with the comparison with the date as a string,

you can replace the condition in the previous post to:

from path where DateRaised>= makedate(2010)

or

from path where year( DateRaised) >=2010

Hope this helps,

Erich

[#4]

Thanks

It works!