Show Last day -1 helppp

[simoevry]

Hii

I want to show last day but his dont work for me

load

[selling],

[Date],

Year (date(date#([Date],'YYYYMMDD'),'YYYYMMDD')),

FROM [lib://AttachedFiles/Rp2.xls]

(biff, embedded labels, table is Rp2$)

Where

year (date(date#(Date,'YYYYMMDD'),'YYYYMMDD')) = year(now())

AND MONTH (date(date#(Date,'YYYYMMDD'),'YYYYMMDD'))=Month(Now())

AND DAY(date(date#(Date,'YYYYMMDD'),'YYYYMMDD')=Day(Now()-1));

plzz help me

[edmondo_tassi]

Try use Num(Date) in spite of Date in date format on condition, is more simple and the behaviour is like Excel.

load

[selling],

[Date],

Year (date(date#([Date],'YYYYMMDD'),'YYYYMMDD')), // <-- an extra comma?

FROM [lib://AttachedFiles/Rp2.xls]

(biff, embedded labels, table is Rp2$)

Where

year (date(date#(Date,'YYYYMMDD'),'YYYYMMDD')) = year(now())

AND MONTH (date(date#(Date,'YYYYMMDD'),'YYYYMMDD'))=Month(Now())

AND DAY(date(date#(Date,'YYYYMMDD'),'YYYYMMDD')=Day(Now()-1));

replaceing

where

num(date#(Date,'YYYYMMDD')))= num(now())-1;