topic Re: Date conversion in QlikView

Date conversion

srinivasa1 — Sat, 24 Nov 2012 23:04:22 GMT

Hi,

Im just trying to use databas date like 20121016 into qlikview as 10/16/12(MM/DD/YY) but im getting result as '6/19/56989

Can pls guide me how i can format this as 10/16/12(MM/DD/YY).

Thanks in advance.

Re: Date conversion

swuehl — Sat, 24 Nov 2012 23:14:59 GMT

Try like

=Date(Date#(20121016 ,'YYYYMMDD'),'MM/DD/YY')

resp.

=Date(Date#(DATEFIELD ,'YYYYMMDD'),'MM/DD/YY')

Re: Date conversion

srinivasa1 — Sun, 25 Nov 2012 02:51:54 GMT

Thanks for your reply but im applying this result in barchart comes as as group or single staked row.

Re: Date conversion

its_anandrjs — Sun, 25 Nov 2012 06:37:27 GMT

Do script some thing like

=Date(Date#('20121016' ,'YYYYMMDD'),'MM/DD/YYYY')

=Date(Date#(DateField,'YYYYMMDD'),'MM/DD/YYYY')

Regards,

Anand

Re: Date conversion

its_anandrjs — Sun, 25 Nov 2012 06:39:39 GMT

If use in bar chart make modified date field or use this script in your expression

Date(Date#(DateField,'YYYYMMDD'),'MM/DD/YYYY') as ModifiedDateField

Regards,

Anand

Re: Date conversion

swuehl — Sun, 25 Nov 2012 11:59:32 GMT

srinivasa1, I think I have not fully understood your issue.

Could you post a little sample qvw, or some screenshots of your chart and some sample lines of your data?

Re: Date conversion

Sun, 25 Nov 2012 15:57:42 GMT

try:

date( mid(20121016,5,2) &'/' &right(20121016,2) &'/' &mid(20121016,3,2) )

date( mid(YourDate,5,2) &'/' &right(YourDate,2) &'/' &mid(YourDate,3,2) )

Re: Date conversion

srinivasa1 — Tue, 27 Nov 2012 02:10:48 GMT

Thaknks swuel for your reply .im sorry for dealy to reply as was bit busy some other work..i found some alternative soluation for that..let me try that.once again thanks for your effort..

Re: Date conversion

srinivasa1 — Tue, 27 Nov 2012 02:11:36 GMT

Thaknks l for your reply .im sorry for dealy to repl y as was bit busy some other work..i found some alternative soluation for that..let me try that.once again thanks for your effort..