covert a number in to Date format YYYYMMDD

[naaniibabu]

I have one number i want to convert in to a date format

the size of the value is =8 Char
20091212
i ant to conver it in to a date format
my sysyem doent understand wether its adate or not its taking as a number

Thanks
Nani

[MikeTheBike]

@naaniibabu
Hi
assuming that it is always an 8 digit number as yyyymmdd then something like

Dim intDateNumber as long
Dim strDateNumber as string
Dim Thisdate as Date
 
intDateNumber = 20091212
strDateNumber = CStr(intDateNumber)
 
ThisDate = DateSerial(left(strDate,4),Mid(strDateNumber,5,2),right(strstrDate,2))

In VBA or VB6 you don't need to convert to a string, but not sure in .NET (I assume you will need to!).


MTB

[naaniibabu]

Thanks MTB

todya i tried it in my machine it is not working
pls let me know what happend

Thanks
Nani

[MikeTheBike]

@naaniibabu
Hi

I have lost my crystal ball, so maybe you could let US know what happened !!?

MTB

[naaniibabu]

Hi ,

It's Working Fine thanks alot ,for your guidance

Thanks
Nani