time stamp issue

[#1]

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

[#2]

still does not work

[gaurav2017]

hi,

can you send some sample data in excel or a qvw?

Regards

[rwunderlich]

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