Discussion Board for collaboration on QlikView Scripting.
i am importing raw data from MS Access and Date column in MS Access has date followed by time stamp
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
Now() instead of today()
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
write according to this syntax
load *,date(Date,'M/D/YYYY') as Date_new
from MS access table ;
load * resident tab1 where Date_new=$(tdate);
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...
Try this one
Let tdate= Date(today(),'M/D/YYYY');
Ex: load * from MS access table where floor(Date(Date,'M/D/YYYY'))=$(tdate);
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
Use let statement to define your date and use in load like
load * from test where Date='$(tdate)';
as mentioned in my original post, i hav already declared the variable and your suggestion doesnot work
You can use-
//first load table from access...
// Use load statement...
MakeDate(Year(Date),month(Date),Day(Date)) as Final Date,
Drop Table Temp;
Hope it will resolve the issue.