Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
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
Regards,
Khasim.
Like this
Calls:
load [Complaint_ID]
,date(floor([complaint_date])) as complaint_date
,[complaint_no]
,[count]
,date(floor([Reminder_Date])) as Reminder_Date
,[NewAppointment]
,
Hi,
Can you paste your script here?
you can try something like this
load
f1,
Date(floor(YourDateField)) as Date,
f3;
sql select * from table.
Regards
ASHFAQ
Hi, Can you try?:
Convert(datetime,[Date_Field],103) as Date_Field
Try
convert(varchar(10),[Date_Field],103) as Date_Field
Hi,
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.
Regards,
Andrei
HI Ruben,
Thanks for Reply but its not working
Regards,
Khasim
Hi Ashfaq,
My Script is
Calls:
SELECT [Complaint_ID]
,Convert(Varchar,[complaint_date],103) as complaint_date
,[complaint_no]
,[count]
,Convert(datetime,[Reminder_Date],103) as Reminder_Date
,[NewAppointment]
,
Hi,
From where you are reading this SQL or QVD?
regards
ASHFAQ
Hi,
From SQL
If it is qvd try like this
Calls:
SELECT [Complaint_ID]
,date(floor([complaint_date])) as complaint_date
,[complaint_no]
,[count]
,date(floor([Reminder_Date])) as Reminder_Date
,[NewAppointment]
,