Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have the below code:
LOAD Plant,
Part_Type,
Contract_Type,
BUEqui,
Country,
Strategic_Flag,
YearMonth,
Fiscal_Month,
Calendar_Year,
ITM_Consumption,
ITM_IB,
YTD_Consumption,
YTD_IB,
YTD_Consumption_LY,
YTD_IB_LY,
ADJ_CONS_YTD_LY,
Country_CR,
Country_Final_temp,
Country_Final
FROM
[\..\T1.qvd]
(qvd) where YearMonth = '201712';
when i give this where clause i am getting 0 records and when i remove the where condition i am getting the output..
Can you please tell me where i am doing wrong..
Thanks,
Bharat
How is YearMonth created in the qvd file? May be it is a date field rather than string... try this
Where YearMonth = MakeDate(2017, 12);
How is YearMonth created in the qvd file? May be it is a date field rather than string... try this
Where YearMonth = MakeDate(2017, 12);
Hi,
YearMonth column is in what format?
Thank you sunny bhai it worked.. can you please tell me is it because of string it did not get executed..
No, you MonthYear field is a actual date field and you were comparing it to a number. Using MakeDate(), we created a date to compare the date field.
Ohh ok. Thank you Sunny Bhai..