How to convert ToString to ToDate

[swanand_deshmukh]

im facing a problem regarding date

19-Nov-19 This date is imputed as 43788 ho my question is how i convert it into date format

[RAMESH_G (Ramesh)]

(Convert a string to date - #6 by Palaniyappan):

[gulshiyaa]

Hi @swanand_deshmukh

Please repeat your questio i cant understand 19-nov-19 date u have and what is that 43788?

[Palaniyappan (Forum Leader)]

the expression be like this
DateTime.FromOADate(Convert.ToDouble(“43788”)).ToString(“dd-MMM-yy”)

Cheerss @swanand_deshmukh

[vickydas (vicky)]

Hello @swanand_deshmukh
the number you are getting is also a date but in OA Format so to get the date in your required form use this code

Date.FromOADate(cdbl(yourstringVariable))

this will get the required output in Date Datatype

[swanand_deshmukh]

@vickydas yes i use this but it shows the error

[vickydas (vicky)]

Hello @swanand_deshmukh
you are assigning a string value to it the code you just applied will give you the date datatype value
if you want it in string
than use this code

Date.FromOADate(cdbl(yourstringVariable)).tostring("dd-MMM-yy")

as also suggested by @Palaniyappan in the earlier post

[swanand_deshmukh]

Execute Non Query: Conversion from string “” to type ‘Double’ is not valid.

[swanand_deshmukh]

yess!! my date format is 18-Nov-19

[swanand_deshmukh]

is any one here plz help me out