
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unable to change a date format
HI there,
i have problem changing 1 of my date column to another format - mydate
i used code as such - Date("Start Date",'DD-MM-YYYY') as mydate , why my year become "57069" ?
Rgds
Jim
- Tags:
- new_to_qlikview
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=Date(Date#(StartDate,'YYYYMMDD'),'DD-MM-YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jim
As you know, your startdate is not in the correct date format... you have to use date# function as mentioned below..
=Date(date#("Start Date"'),'DD-MM-YYYY') as mydate
Happy to help!
Sreeni

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you explain why has to put "Date#" , then (StartDate,'YYYYMMDD') ? i know this is the format 'DD-MM-YYYY'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I thought the "Date" is already a date function?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
First you have to tell qlikview that your Start Date is a date field in the format of YYYYMMDD, for this you have to use Date# interpretation function next you need to format the date to your desired format using Date formatting function.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Welcome
