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

[sushil353]

try:

Now() instead of today()

HTH

Sushil

[#3]

how will that help...

i need a formula to us on Date column in MS Access  while loading it in Qlikview script to remove time stamp

any idea

[#4]

write according to this syntax

tab1:

load *,date(Date,'M/D/YYYY') as Date_new

from MS access table ;

load * resident tab1  where Date_new=$(tdate);

[#5]

You can try -  MakeDate(Year(Date),month(Date),Day(Date))

while loading the access data on qlikview... this will remove the time from time stamp

hope it helps...

[kumarnatarajan]

Hi,

Try this one

Let tdate= Date(today(),'M/D/YYYY');

Ex: load * from MS access table where floor(Date(Date,'M/D/YYYY'))=$(tdate);

[#7]

none of the above 3 suggestions are working as its MS Access so its Select instead of Load and the error i am getting for all teh 3 options is type mismatch in SQL query

please advise

[sivarajs]

Use let statement to define your date and use in load like

load * from test where Date='$(tdate)';

[#9]

hi Siv

as mentioned in my original post, i hav already declared the variable and your suggestion doesnot work

thanks

[#10]

You can use-

//first load table from access...

Temp:

select Date,

Data1,

Data2

from AccessTableName;

// Use load statement...

Final Table:

load

Date,

MakeDate(Year(Date),month(Date),Day(Date)) as Final Date,

Data1,

Data2

resident Temp;

Drop Table Temp;

Hope it will resolve the issue.