Extraction SpecificDate

[mario-sarkis]

Dear All,

I have Table that contains A date field as General Form i.e. "42736" I need to extract the first 20 days in from each month ,

how can I write this in the script.

Thank you

hope you can help

[Anil_Babu_Samineni]

Perhaps this? Arrange as per your needs

LOAD AutoNumber(RecNo(), Month(Date)) as ID,Month(Date) as Month, Date Where AutoNumber(RecNo(), Month(Date)) <= 20;

LOAD Date(MinDate + IterNo() - 1) as Date

While Date(MinDate + IterNo() - 1) < MaxDate;

LOAD MakeDate(2014) as MinDate,

MakeDate(2015) as MaxDate

AutoGenerate 1;

[MarcoWedel]

please post some more sample data and your expected result.

thanks

regards

Marco

[mario-sarkis]

Dears , I solve it by Using that "DAY" Function and I extracted my Data with the condition of where Day < 20

Thanks