topic makeDate in QlikView

makeDate

srinivasa1 — Thu, 17 Feb 2011 10:39:29 GMT

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

thx adavance.

makeDate

deepakk — Thu, 17 Feb 2011 10:47:34 GMT

hi Srini,

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

makeDate

lucas4bi — Thu, 17 Feb 2011 10:47:47 GMT

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')

makeDate

srinivasa1 — Thu, 17 Feb 2011 10:48:10 GMT

This post has 0 verified answers | 0 Replies | 1 Follower

Suggest an Answer

Stop Following Follow this Question ...

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.

makeDate

tresB — Thu, 17 Feb 2011 10:51:26 GMT

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').

makeDate

srinivasa1 — Thu, 17 Feb 2011 10:53:38 GMT

thx deepu its working

makeDate

srinivasa1 — Thu, 17 Feb 2011 10:56:12 GMT

thx yaar.its working now as deepk script.