How to use Monthend()

[Anonymous]

Hi,

i creted in my script two flags,

the first :

if(CalendarDate=MonthStart(CalendarDate),1,0) as Start_Flag   //in the aim to know if is the first day of the month

and a second :

if(CalendarDate=MonthEnd(CalendarDate),1,0) as end_Flag   //to know if is the last day in the month

but the second doesn't work !! it gives me 0 to all fields.

can you help me ?!

[Anonymous]

I found my problem
I used "nr_pmc_b" alias QV, and a "nr_pmc" for OLE DB, OLE DB turns out that the fields in capital letters, so I had to use NR_PMC.

simple

thank you.