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

Quote:

Originally Posted by 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

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

Expand|Select|Wrap|Line Numbers

 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

Quote:

Originally Posted by naaniibabu

Thanks MTB

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

Thanks
Nani

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

covert a number in to Date format YYYYMMDD

re: covert a number in to Date format YYYYMMDD

re: covert a number in to Date format YYYYMMDD

re: covert a number in to Date format YYYYMMDD

re: covert a number in to Date format YYYYMMDD

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/about