Assign: String was not recognized as a valid DateTime error

Help Studio
, ,
1

Hello Community,

When I try to convert a date from excel, it pops up “Assign: String was not recognized as a valid DateTime” error, any one can help? Thanks.

20210518170430
202105181704301139×929 157 KB

2

Hi @li.yu

What is the format on excel, can you show us the excel file date format.

Thanks

3

@li.yu

Check below for your reference

Use output datatable activity and messagebox to view the data how it appears, If it appears in date format then check below

If date is showing as number then check below

Hope this may help you

Thanks

1 Like
4

the excel date format is Custom, m/d/yyyy hh:mm AM/PM

5

Make Sure check excel file once and check hh:mm:ss

Or Use this code once

VariableA = Convert.ToDateTime(Your_String)

VariableA Type is System.DateTime

Regards
Chethan P

6

Hi @li.yu
try this way

DateTime.ParseExact(changeday,“MM/dd/yyyy hh:mm:ss tt”,System.Globalization.CultureInfo.InvariantCulture)

7

Thanks for sharing Srinivas!

8

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