Discussion Board for collaboration on QlikView Scripting.
Can any body solve this Error when i connect to data base Table showing error like
I Change Given format below
,Convert(Varchar,[Date_Field],103) as Date_Field is it right?
Thanks in Advance
Go to Solution.
,date(floor([complaint_date])) as complaint_date
,date(floor([Reminder_Date])) as Reminder_Date
Can you paste your script here?
you can try something like this
Date(floor(YourDateField)) as Date,
sql select * from table.
Hi, Can you try?:
Convert(datetime,[Date_Field],103) as Date_Field
convert(varchar(10),[Date_Field],103) as Date_Field
You are trying to use specific MSSQL convert() function in your SQL statement, it's not quite right.
Try Ashfaq's solution to solve your problem.
Thanks for Reply but its not working
My Script is
,Convert(Varchar,[complaint_date],103) as complaint_date
,Convert(datetime,[Reminder_Date],103) as Reminder_Date
From where you are reading this SQL or QVD?
If it is qvd try like this