Where Date Condition for loading?????

[praveenkumar_ma]

Hello Experts,

I have a where date condition like date should load evry8th of every month and monthened of every month

like:

Where DATE = every monthend  and 8th of every month ????

How to write where condition for date in dataloadeditor ????

Thanks in Advance

Regards

PM

[arvind_patil]

For Monthend you can try below.

Datatable:

.

DateField

..

From

...

FinalData:

..

..

Resident Datatable;

Right Join (FinalData)

LOAD Date(Floor(MonthEnd(DateField))) as MonthendDate

Resident Datatable;

Thanks,

Arvind Patil

[arvind_patil]

For Monthend you can try below.

Datatable:

.

DateField

..

From

...

FinalData:

..

..

Resident Datatable;

Right Join (FinalData)

LOAD Date(Floor(MonthEnd(DateField))) as MonthendDate

Resident Datatable;

Concatenate(FinalData)

FinalData1:

..

..

Resident Datatable;

Right Join (FinalData)

LOAD Date(Floor(MonthStart(DateField))+7) as EightDate

Resident Datatable;

Drop table Datatable;

Thanks,

Arvind Patil