Date and Time formatting from excel

Build
#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
image.png1041×462 14.1 KB

#13

It worked! thank you vry much!

2 Likes
#14