Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nicouek
Creator
Creator
‎2021-11-01 11:59 AM

Conversion or Rewrite

Hello Everybody

I have a  [DateField] from the source showing the values "20211025" I would like some help transforming it into  (10/25/2021).

Please help...

Thank you

720 Views
0 Likes
1 Solution

Accepted Solutions
marcus_sommer
MVP
MVP
‎2021-11-01 12:14 PM

You could try: date(date#([DateField], 'YYYYMMDD'), 'MM/DD/YYYY')

- Marcus

View solution in original post

706 Views
2 Replies
marcus_sommer
MVP
MVP
‎2021-11-01 12:14 PM

You could try: date(date#([DateField], 'YYYYMMDD'), 'MM/DD/YYYY')

- Marcus

707 Views
nicouek
Creator
Creator
‎2021-11-01 01:53 PM
Author

In response to marcus_sommer

Wow, that was incredible! Thank you again...

671 Views
0 Likes