topic Re: Date format issue in QlikView

Date format issue

ravindraa — Tue, 22 Mar 2016 05:41:21 GMT

Hi all,

I have struck one please give me some suggestion to come out from this.

actually i am loading the data from data base the date format is YYYY-MM-DD-HH-MM, but we need YYYY-MM-DD format only, for that i wrote code in edit script level like below

date(Date,'DD/MM/YYYY') as Database_Date,

some date's are in Number format those are not changing , please give suggestion how to change numbers format dates into dates.

please find the attachment .

Thanks in advance.

Re: Date format issue

Chanty4u — Tue, 22 Mar 2016 05:43:38 GMT

hi,

SET DateFormat='DD/MM/YYYY'; // You can set whatever format you want-date or timestamp

Re: Date format issue

Chanty4u — Tue, 22 Mar 2016 05:44:58 GMT

Alt(

Date(Floor(Date#("field",'YYYY-MM-DD-HH-MM')),'DD/MM/YYYY'),

Date(Floor(Date("field",'YYYY-MM-DD-HH-MM')),'DD/MM/YYYY')

) as "Date",

Re: Date format issue

Chanty4u — Tue, 22 Mar 2016 05:47:37 GMT

chk dis FYI

Why don’t my dates work?

Re: Date format issue

tresB — Tue, 22 Mar 2016 05:49:01 GMT

Your numbers are nine digit. Perhaps this is not UNIX date. What date format is this? What date do you expect from a number - 148435331?

Re: Date format issue

tresB — Tue, 22 Mar 2016 05:52:47 GMT

Well I guess I have found it. Try loading the date field like:

Date(35065+YourNumber/86400-7/24)

So the entire statement:

If(Len(Date)>5, Date(35065+Date/86400-7/24), Date(Date, 'DD/MM/YYYY')) as Date,

Re: Date format issue

ravindraa — Tue, 22 Mar 2016 05:55:39 GMT

Thanks for replying all,

Hi Tresesco,

I have loaded data form data base then i am checking data , here i am found this format i have tried to change this format but it is not chaining the format.

i want data format like following format Tresesco YYYY/MM/DD , please give me suggestion how to change this format.

Thanks in advance................................

Re: Date format issue

tresB — Tue, 22 Mar 2016 05:57:50 GMT

Check my updated reply above.

Re: Date format issue

ravindraa — Tue, 22 Mar 2016 06:03:48 GMT

Thank you very much Trsesco,

it is working for me, could you explain me about this logic -Date(35065+Date/86400-7/24)

Thank you very much Tresesco............................

Re: Date format issue

tresB — Tue, 22 Mar 2016 06:34:15 GMT

Check it here