Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

extraction of date and formatting

How can I extract the date in the format of yyyy-mm-dd from the given highlighted data

1 Solution

Accepted Solutions
Anonymous
Not applicable

you Need to Format it to your requirements.

date(date#(left(text(Disposal_Date), 8),'YYYYMMDD'),'YYYY-MM-DD')

View solution in original post

5 Replies
trishita
Creator III
Creator III
Author

i did left(Disposal_Date, 😎 till now

Anonymous
Not applicable

what Format is Disposal_Date ? Number?

then try

left(text(Disposal_Date), 😎

trishita
Creator III
Creator III
Author

i currently did left(Blige_Disposal_Date,8) and for that my data is coming like  20161215..I want to have it in the form  2016-12-15 format..

Anonymous
Not applicable

you Need to Format it to your requirements.

date(date#(left(text(Disposal_Date), 8),'YYYYMMDD'),'YYYY-MM-DD')

trishita
Creator III
Creator III
Author

Date(Date#(Sludge_Date, 'YYYYMMDD'),'YYYY-MM-DD')

Its working..anyways thanks