topic Re: Date Format issue in QlikView

Date Format issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i am getting Date format iisue!

DB:

2017-04-12 21:51:51

QV:

1/9/0000 21:51:51

Regards,

Re: Date Format issue

Anil_Babu_Samineni — Tue, 25 Apr 2017 04:25:19 GMT

May be use this?

=Timestamp('2017-04-12 21:51:51')

Re: Date Format issue

Anonymous — Tue, 25 Apr 2017 04:28:34 GMT

Nope already tried this

Re: Date Format issue

Anil_Babu_Samineni — Tue, 25 Apr 2017 04:30:57 GMT

Where are you tried this? For me it is working

=Date(Timestamp('2017-04-12 21:51:51'),'YYYY-MM-DD hh:mm:ss')

Re: Date Format issue

prma7799 — Tue, 25 Apr 2017 04:37:43 GMT

Try like below

=Timestamp# ('2017-04-12 21:51:51 ' )

=Timestamp#(Date#('2017-04-12 21:51:51 ' , 'YYYY-MM-DD'))

Re: Date Format issue

Anonymous — Tue, 25 Apr 2017 04:39:47 GMT

In Bar chart taking date column as dimension

Re: Date Format issue

Anonymous — Tue, 25 Apr 2017 04:41:04 GMT

still it is showing 1/9/000 as date in qlikview

Re: Date Format issue

Anil_Babu_Samineni — Tue, 25 Apr 2017 04:41:14 GMT

You can use Calculated Dimension the same if you want

Re: Date Format issue

Anil_Babu_Samineni — Tue, 25 Apr 2017 04:41:34 GMT

Can you provide sample to work on it

Re: Date Format issue

tresB — Tue, 25 Apr 2017 04:43:54 GMT

May be :

=Date(Timestamp#('2017-04-12 21:51:51'),'YYYY-MM-DD hh:mm:ss') )

Re: Date Format issue

ramasaisaksoft — Tue, 25 Apr 2017 04:49:04 GMT

Hi Nagesh,

check the below statements in your code at Main tab.

step 1:-

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

step 2:-

Date(Date#("date Field Name",'YYYY-MM-DD'),'YYYY-MM-DD')

Step 3:-

try to reload other date filed column may be the data only issue some times.

Re: Date Format issue

sumitjadhav — Tue, 25 Apr 2017 08:27:40 GMT

Hi Nagesh,

Try the Below Expression For Creating the Date Field From the Given Data

-->>date(left(Timestamp#('2017-04-12 21:51:51','DD-MM-YYYY'),10),'DD-MM-YYYY')

Hope it Works Well!!!

Thank's & Regards,

Sumit Jadhav.

Re: Date Format issue

Anonymous — Tue, 25 Apr 2017 09:17:54 GMT

Hi Sumit ,

Thanks for your kind response ,

here problem is not formatting , while loading Oracle DB to QV

ex:

Oracle DB Records like below:

2017-04-12 21:51:51

In QV loading like below

1/9/0000 21:51:51

Regards,

Re: Date Format issue

sumitjadhav — Tue, 25 Apr 2017 10:52:13 GMT

Hi Nagesh,

Then you have to change the date format from the data source itself,i.e,from oracle database in your case,

and then load it in Qlikview,The Problem is Because the date value from Database is in Timestamp Format.

By taking help of Oracle Database developer create the date field in Proper format in Oracle Database itself.

Hint:You have to change the format in the Querry from Which you are Extracting this Date field.

Thank's & Regards,

Sumit Jadhav.

Re: Date Format issue

Anonymous — Tue, 25 Apr 2017 11:20:24 GMT

Thanks Sumit Doing Same

Re: Date Format issue

kamielrajaram — Tue, 25 Apr 2017 12:32:46 GMT

Hi,

have you tried to use the makedate function in your script, something like this

makedate(subfield('2017/04/25','/',1) ,subfield('2017/04/25','/',2) , subfield('2017/04/25','/',SubStringCount('2017/04/25','/')+1))

Kind Regards

Kamiel