makeDate

[srinivasa1]

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

thx adavance.

[deepakk · Accepted solution]

hi Srini,

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

[lucas4bi]

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]

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

Suggest an Answer

Reply

Stop FollowingFollow this Question...

Send to Friend

Add to Favorites

Report Abuse

Edit

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]

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]

thx deepu its working

[srinivasa1]

thx yaar.its working now as deepk script.