Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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
Partner

hi Srini,

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

View solution in original post

6 Replies
deepakk
Partner
Partner

hi Srini,

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

lucas4bi
Partner
Partner

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.