
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Converting Date format
HI,
I have a full date with DD/MM/YYYY hh:mm format. But i'd like to know how to split it to get DD/MM/YYYY format. Vizlib calendar only accept DD/MM/YYYY format
cdt
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1: Date(dateField,'DD/MM/YYYY') >>>>>>> If datefield is stored as date
2: Date(Date#(dateField,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY') >> If datefield is stored as string
3: Date(Left(trim(dateField),10),'DD/MM/YYYY')
Regards,
Prashant Sangle
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can easily just create a new data field from the existing one:
ex.
New_Data_field_name = Date( Old_data_field_name, 'DD/MM/YYYY' )
Old_data_field_name would correspond to the field with the full date with DD/MM/YYYY hh:mm format
You can as well create this field in the Loading script:
Date( "Old_data_field_name", 'DD/MM/YYYY' ) as New_Data_field_name

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1: Date(dateField,'DD/MM/YYYY') >>>>>>> If datefield is stored as date
2: Date(Date#(dateField,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY') >> If datefield is stored as string
3: Date(Left(trim(dateField),10),'DD/MM/YYYY')
Regards,
Prashant Sangle
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can easily just create a new data field from the existing one:
ex.
New_Data_field_name = Date( Old_data_field_name, 'DD/MM/YYYY' )
Old_data_field_name would correspond to the field with the full date with DD/MM/YYYY hh:mm format
You can as well create this field in the Loading script:
Date( "Old_data_field_name", 'DD/MM/YYYY' ) as New_Data_field_name
