Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Como Formatar Dia, Mes, Ano

Pessoal boa noite.

Como formatar o Dia, Mes e Ano para um campo de data que vem da seguinte forma 20140322?

Usei o day(), month() e year() mas os dados não ficam ok nos campos.

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

t1:

load * inline

[ Data

20140322

20140323

]

;

t2:

load

Left(Data,4) as Year,

mid(Data,5,2) as Month,

Right(Data,2) as day

Resident t1;

drop table t1

2015-05-08 05_35_25-Edit Script [C__Users_Katarzyna_Desktop_qvw_dasa.qvw_].png

View solution in original post

2 Replies
robert_mika
Master III
Master III

t1:

load * inline

[ Data

20140322

20140323

]

;

t2:

load

Left(Data,4) as Year,

mid(Data,5,2) as Month,

Right(Data,2) as day

Resident t1;

drop table t1

2015-05-08 05_35_25-Edit Script [C__Users_Katarzyna_Desktop_qvw_dasa.qvw_].png

Clever_Anjos
Employee
Employee

t1:

load Date(Date#(Data,'YYYYMMDD')) as Data inline

[ Data

20140322

20140323

]

;