Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey can any one guide me how can i make dateformat from 19380820 ie mm/dd/yyyy.
thx adavance.
hi Srini,
This should help you Date(Date#(19830920,'YYYYMMDD'),'DD/MM/YYYY')
hi Srini,
This should help you Date(Date#(19830920,'YYYYMMDD'),'DD/MM/YYYY')
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')
hey can any one guide me how can i make dateformat from 19380820 ie mm/dd/yyyy.
thx adavance.
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').
thx deepu its working
thx yaar.its working now as deepk script.