topic Re: Date format when importing through ODBC in QlikView

Date format when importing through ODBC

Thu, 23 May 2013 06:34:56 GMT

I am obtaining data via an ODBC connection from an Oracle database. I am a busiess user and the data is being called in from a view created by our IT department.

I am extracting the data in a qvd file and then using it for graphs. Those fields which are date format, Qlikview is not inheriting the format and values are coming unformatted like 35370, 36982, etc.

Is there any way of changing the format of the field in Qlikview.

Thanks.

Re: Date format when importing through ODBC

Thu, 23 May 2013 06:42:25 GMT

changing the format of the field in Qlikview.

date(fieldname)

date(fieldname,'DD-MM-YYYY')

Re: Date format when importing through ODBC

Sokkorn — Thu, 23 May 2013 06:54:57 GMT

Hi,

That correct. QlikView will translate all date data into number format. To format into specific date field, you need to use Date() function when you load data or via expression.

For example:

1. Use in load script

Date(DateField,'DD-MM-YYYY') AS [MyDate], //Ex. Date(35370,'DD-MM-YYYY') return 01-11-1996

2. Use expression

=Date(DateField,'DD-MM-YYYY')

Regards,

Sokkorn

Re: Date format when importing through ODBC

er_mohit — Thu, 23 May 2013 06:57:53 GMT

Try this

Date(Date#(Datefield,'DD-MM-YYYY'),'DD-MM-YYYY') as Date

the first format in date# function is your default format and 2nd one format is which you want either same or different like in below syntax

Date(Date#(Datefield,'DD-MM-YYYY'),'DD/MM/YYYY') as Date

hope it helps