Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Can anyone provide me pseudo code for below requirement, i am finding difficulty in getting code for beginning of prior moth in script.Please find the underlined content.
req:
Ex: WO:
wo_Num,
code,
c_code,
Wo_completionDate,
Wo_requestdate,
ProjNum
d_code
From
Sumarry:
*,
Month(date(now())) as Month,
year(date(now())) as Year,
d_code as [source],
count(wo_number) as [No Of Work Orders]
resident WO where code= 1 and c_code = '01' group by .....;
Best Regards,
Ganesh.
... Where WO_completionDate >= AddMonths(MonthStart(Today()),-1) and WO_completionDate <= MonthEnd(Today())
HIC
... Where WO_completionDate >= AddMonths(MonthStart(Today()),-1) and WO_completionDate <= MonthEnd(Today())
HIC