Date Format issue

[Anonymous]

Hi All,

i am getting Date format iisue!

DB:

2017-04-12 21:51:51

QV:

1/9/0000 21:51:51

Regards,

[ramasaisaksoft]

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.

[sumitjadhav]

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.

[Anonymous]

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,

[sumitjadhav]

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.

[Anonymous]

Thanks Sumit Doing Same

[kamielrajaram]

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