

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Character to Date
Dear friends,
Its Urgent for me, if anybody know then please help us.
How can i convert Character formate into Date Formate in QlikView.
Thanks and Regards,
Vishal


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use the date#() function:
Date#(DATEASCHAR,'YYYY-MM-DD') as DateAsQVDate,
please check the QV date and time format codes to create an appropriate format code string.
--
Stefan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Vishal,
You can use the Date#() format to tell QlikView how to interpret a string as a date value (See the F1 help for examples), and then use Date() to format this into the date format you want.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Use Date# function like
Date#(Datefield , 'DD/MM/YYYY')
But first check what is your date format in DateFormat variable according to that put date format
SET DateFormat='DD/MM/YYYY';
Regards,
Anand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Vishal,
You have to use date#() function.
For example, if your date field is like this : '20130218' (in text format).
Use the function to convert to date format like this :
Date#(FieldName, 'YYYYMMDD') as FieldName // the 2nd parameter is the input format
Your field is now numeric, if you want to modify the output format, you have to do this :
Date(Date#(FieldName, 'YYYYMMDD'),'DD/MM/YYYY') as FieldName // the output format will be DD/MM/YYYY
Hope that helps you
Martin Favier


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Vishal,
You have to use date#() function.
For example, if your date field is like this : '20130218' (in text format).
Use the function to convert to date format like this :
Date#(FieldName, 'YYYYMMDD') as FieldName // the 2nd parameter is the input format
Your field is now numeric, if you want to modify the output format, you have to do this :
Date(Date#(FieldName, 'YYYYMMDD'),'DD/MM/YYYY') as FieldName // the output format will be DD/MM/YYYY
Hope that helps you
Martin Favier


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Vishal,
Test this one : Date(Date#('18-02-2013','dd-MM-yyyy'),'dd/MM/yyyy')
Try to convert with your field : Date(Date#(MyDate,'dd-MM-yyyy'),'dd/MM/yyyy')
Regards,
Sokkorn
