Date and Time formatting from excel

Help
1

Hello.

I’m assigning a row containing date from excel to a variable, such as:

Assign
birthday = row(“生年月日”).ToString

The row contains date in format of yyyy/MM/dd, but the output from the variable is yyyy/MM/dd hh:mm:ss.
What should I do to make it stay yyyy/MM/dd?

Please help.

Regards.

2

Try this

DateTime.ParseExact(“yourString”,“yyyy/MM/dd”,System.Globalization.CultureInfo.InvariantCulture)

Thanks,
Prankur

3

@PrankurJoshi Thank you for your fast reply!

Hmm… I am extracting the data from Data Table row though… Will it still be working without row().ToString ?

Regards

4

You have to use an Assign activity

image

5

It gives me error message box
err

6

Check the string value what you are getting, if possible paste it here

7

Like this

DateTime.ParseExact(row(“生年月日”).ToString,“yyyy/MM/dd”,System.Globalization.CultureInfo.InvariantCulture)

8

The actual value what you are reading from sheet

9

The actual value what you are reading from sheet

excel

10

Try this

Main.xaml (8.1 KB)

This will help you understand it better

1 Like
11

Hmm… The output still showed me the hh/mm/ss.

12

No it does not, see the output of write line Activity

image
image1041×462 14.1 KB

13

It worked! thank you vry much!

2 Likes