Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

makeDate

hey can any one guide me how can i make dateformat from 19380820 ie mm/dd/yyyy.

thx adavance.

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

hi Srini,

This should help you Date(Date#(19830920,'YYYYMMDD'),'DD/MM/YYYY')

View solution in original post

6 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi Srini,

This should help you Date(Date#(19830920,'YYYYMMDD'),'DD/MM/YYYY')

lucas4bi
Partner - Creator
Partner - Creator

You should work with the left(), right() or mid() functions.

Like this: Date( Makedate( Left(DATE,4), Mid(DATE,5,2) , Right(DATE,2)) , 'MM/DD/YYYY')

srinivasa1
Creator II
Creator II
Author

PoorPoorFairFairAverageAverageGoodGoodExcellentExcellent Not Answered This post has 0 verified answers | 0 Replies | 1 Follower

Top 500 Contributor
Points 246
srinivasa1 posted on 02-17-2011 4:39 AM

hey can any one guide me how can i make dateformat from 19380820 ie mm/dd/yyyy.

thx adavance.

tresesco
MVP
MVP

what does your number 19380820 mean? Is it 1930(Year) 08 (month) and 20(day)? if it is so you can use DATE# function like : Date#(yourfield,'YYYYMMDD').

srinivasa1
Creator II
Creator II
Author

thx deepu its working

srinivasa1
Creator II
Creator II
Author

thx yaar.its working now as deepk script.