How to convert ToString to ToDate

#1

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

1 Like
#2

(Convert a string to date):

1 Like
#3

Hi @swanand_deshmukh

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

#4

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

Cheerss @swanand_deshmukh

1 Like
#5

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

1 Like
#6

@vickydas yes i use this but it shows the error

Untitled%20123
Untitled%201231119×448 24.4 KB

#7

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

1 Like
#8

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

#10

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

#11

is any one here plz help me out

#12

Hello @swanand_deshmukh
can you tell me what issue’s are you facing ?