Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
raZor
Contributor III
Contributor III

How to convert $ascii $ text to date

Hi All,

 

I have dates like July 26, 2023.

How to conver to date?

Thanks in advance,

Qliker

Labels (5)
1 Solution

Accepted Solutions
raZor
Contributor III
Contributor III
Author

Hi, 

Thanks for replying, how about December 12, 2023?

date(date#(YourField, 'MMMM DD, YYYY'), 'DD.MM.YYYY')

 

As MMMM is ok for July but for all months?

 

Regards,

 

View solution in original post

3 Replies
marcus_sommer

If all period-parts are properly covered from your interpretation variables (usually at the beginning of your script) you may use:

date(date#(YourField, 'MMMM DD, YYYY'), 'DD.MM.YYYY')

raZor
Contributor III
Contributor III
Author

Hi, 

Thanks for replying, how about December 12, 2023?

date(date#(YourField, 'MMMM DD, YYYY'), 'DD.MM.YYYY')

 

As MMMM is ok for July but for all months?

 

Regards,

 

marcus_sommer

The mentioned interpretation-variable with the listing of long monthnames must be identically to the format-pattern of this date-field and then all dates would be correctly recognized. These variables mustn't be mandatory static at the beginning of the script else they could be changed multiple times within the script - if there is any need to handle anything differently.