Limit Date load with Monthend Date Contition

[Upali_Wijearatne]

Hi Expert

I have below script in in my data 

Mlyqty:
load
Date,
Product,
Type,
ST_Qty
FROM
Final_Daily_Stock_Qty.qvd
(qvd)

where Date=MonthEnd(Date)

I want to data only for the Monthend Date . But when I apply above where condition it does not retorn any data. Kindly help me please.

My data table is as follows

[anat]

monthend function return output in date format.

but i can see your date is in source as number format

you try like 

where date==ceil( num(monthend(date)))

[Upali_Wijearatne]

Mlyqty:

//First 100
LOAD
Date,
MonthEnd(Date) as ME,
Product,
Type,
ST_Qty
FROM
Final_Daily_Stock_Qty.qvd
(qvd)
where Date=ceil(num(monthend(Date)))

It still returns no records pls

[Dataintellinalytics]

Since date is in numbers please confirm whether you really have matching record.