topic Re: Limit Date load with Monthend Date Contition in App Development

Limit Date load with Monthend Date Contition

Upali_Wijearatne — Sun, 03 Mar 2024 08:24:46 GMT

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 — Sun, 03 Mar 2024 09:49:38 GMT

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 — Sun, 03 Mar 2024 10:04:45 GMT

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 — Mon, 04 Mar 2024 14:07:03 GMT

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