Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
fisland92
New Contributor III

convert to yyyymm

hi,

how can ı convert DATE to YYYYMMDD format?

like to function in SQL >> to_char(date,'yyyymm')

thanks.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: convert to yyyymm

Try this: Text(Date(YourDateField,'YYYYMMDD'))

View solution in original post

5 Replies
Highlighted
greeshma_k
Contributor III

Re: convert to yyyymm

date(date#(date,'YYYYMMDD'),'YYYYMM')

Highlighted
sunilkumarqv
Valued Contributor II

Re: convert to yyyymm

Hi Hopes this helps

Date(Date#(DateField,'MM/DD/YY'),'YYYYMMDD ')

Highlighted
Not applicable

Re: convert to yyyymm

Try this: Text(Date(YourDateField,'YYYYMMDD'))

View solution in original post

Highlighted
Not applicable

Re: convert to yyyymm

The expression convert your date field in a string

Highlighted
fisland92
New Contributor III

Re: convert to yyyymm

thanks this is more general expression.