How to format the date field

[#1]

Hi All,

I have attached one QVD, that includes two fields:Region,BudgetDate

But that BudgetDate, it seems like a string format, I can't use any Year,Month or others Date function on it, so how to handle this issue?

Thanks.

[nagaiank · Accepted solution]

In the qvd file, the BudgetDate field has YYYY/MM/DD format. In order to load this date as a number, you may use the following script:

Budget:

LOAD Region, Num(Date#(BudgetDate,'YYYY/MM/DD')) as BudgetDate;

LOAD Region,

     BudgetDate

FROM

C:\Users\Kris\Downloads\Budget.qvd (qvd);

I did load your file using the above script and it works. You may use 'Date' function instead on 'Num' function depending on your application.

Hope this helps.