Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

convert to yyyymm

hi,

how can ı convert DATE to YYYYMMDD format?

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

thanks.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

sunilkumarqv
Specialist II
Specialist II

Hi Hopes this helps

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

Not applicable
Author

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

Not applicable
Author

The expression convert your date field in a string

Anonymous
Not applicable
Author

thanks this is more general expression.