Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
i am importing raw data from MS Access and Date column in MS Access has date followed by time stamp
5/16/2013 12:00:00:00
when i load the raw data and i compare the date column with variable declared in script
tdate= date (today(),'M/D/YYYY');
load * from MS access table where Date='$(tdate);
this gives an error of mismatch format
please advise for to resolve in script
thanks
still does not work
hi,
can you send some sample data in excel or a qvw?
Regards
does not remove the time portion from the internal value.
You need to add the floor function
date(floor(Date,'M/D/YYYY')) as Date_new
Read this excellent Technical Brief to understand the details of using date fields in QV.
http://community.qlik.com/docs/DOC-3102
-Rob