
Contributor II
2018-06-19
02:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to convert pythons time.ctime() to a usable format
Hi,
I have data with timestams in the python time.ctime() format.
Example:
"Tue Jun 19 08:40:07 2018"
How can i "transform" this format in a usable date/time format? I would be very happy about helpful suggestions!
😉
795 Views
1 Solution
Accepted Solutions

Partner - Champion III
2018-06-19
03:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you have the date as a string like you show then this will work to interpret the string and convert it into a Qlik date:
=Date#( Mid( FieldOrVariableWithDate ,5,16 ) , 'MMM D hh:mm:ss YYYY' )
2 Replies

Partner - Champion III
2018-06-19
03:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you have the date as a string like you show then this will work to interpret the string and convert it into a Qlik date:
=Date#( Mid( FieldOrVariableWithDate ,5,16 ) , 'MMM D hh:mm:ss YYYY' )

Contributor II
2018-06-19
03:26 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great! Thx!
