Cannot convert string to datetime

Help
#1

String: 30/10/2018 11:06:30 AM

I have tried the below codes but it isn’t working. Pls help

row(“LogTime”)(“dd/MM/yyyy HH:mm:ss”)
Convert.ToDateTime(row(“LogTime”).ToString).ToString("dd/MM/yyyy HH:mm:ss”)
DateTime.ParseExact(row(“LogTime”).ToString, "dd/MM/yyyy HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture)

Thank you xoxo

#2

DateTime.ParseExact(“30/10/2018 11:06:30 AM”, “dd/MM/yyyy HH:mm:ss tt”,
System.Globalization.CultureInfo.InvariantCulture)

1 Like
#3

@KarthikByggari it gives me error
image

#4

What @KarthikByggari suggested, that works well, how are you accessing the Date later?

#5

@PrankurJoshi

I am accessing the value in a excel sheet which is generated from a system.
image

#6

Can you attach workflow

#7

Hi @PrankurJoshi , I have attached sample workflow and excel

Main.xaml (9.0 KB)
11.xlsx (52.9 KB)

#8

time_Conversion.zip (48.1 KB)

please find attached flow

1 Like
#9

@kirti.iyer thank you :slight_smile:

the answer code given in the xaml file:
DateTime.ParseExact(row(0).ToString,“dd/MM/yyyy hh:mm:ss tt”,Nothing).ToString(“HH:mm:ss”)

#10

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