Date conversion from excel column

Help
,
1

hello guys,
i am using row.item(“column name”) but my column contain date type.
declared variable as datatime but it showing error while putting tostring
pls refer below image and correct me.

image
image1028×474 18.8 KB

1 Like
2

Hi @prashantP

Use row.item(“StringValue”)=CDate(row(“StringValue”).ToString

Thanks
Ashwin S

3

Use in the assign activity as

val = datetime.parse(row(“string value”).tostring, “format you are getting from excel”, System.Globalization.CultureInfo.InvariantCulture).tostring(“format you want”)

4

Hello @AshwinS2
thank you for fast response.
as you said i did this variable type change as a string…check below img

image
image857×398 23 KB

after runing process value is typing with time. pls check below img…
image

and having date values in “stingvalue” is in below img…
image

5

Hi @prashantP
Use Convert.ToDateTime(row(“StingValue”).ToString)

or DateTime.ParseExtract(row(“StringValue”).ToString,“dd/mm/yyyy”,System.Globalization.CultureInfo.InvariantCultrue).ToString(“dd/MM/yyyy hh:mm:ss”)

Thanks
Ashwin S

6

hi @HareeshMR
thank you…
but still getting error pls correct me if i miss something ?

image
image1216×508 35 KB

7

Place the cursor on the error so that it will show what is the error in the entire string @prashantP

8

One thing is, change datetime.parse to DateTime.ParseExact @Assetsoft… that will work

9

using exact

image
image830×313 23 KB

10

@prashantP Try below solution

assign str = row(“ur column name”).ToString
assign str = cDate(str).ToString(“dd/MM/yyyy”)

11

hello @indra
pls correct me

image
image1033×581 25.9 KB

12

hi @prashantP

Use val1=CDate(val).ToString(“MM/dd/yyyy hh:mm:ss”)

Thanks
Ashwin S

1 Like
13

thanks @AshwinS2 @indra @HareeshMR
i don’t need time so i removed it
image

14

@prashantP In the assign activity remove str and pass val

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.