Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Find attachment of qv file I want to load data from xlsx file but the date field
I am getting number's I want this date in "DD/MM/YYYY" format in my qvw file.
Hi,
Use in load script as
Load
Date(DateField,'DD/MM/YYYY'),
..From..DataFile
Hope it helps
Celambarasan
Hi,
Use the following load script
LOAD
Date(DateFieldName,'DD/MM/YYYY'),
'
'
'
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
Hi
Thanks for reply
Resolved with
Date (Num(Evaluate(DATE) )) as Date