How to get the time along with AM/PM

Help
21

i am following you till here. but then why are we getting this error? does it have anything to do with row(“Date/Time”).ToString since we are taking the entire row instead of a particular cell which has the date time value.

String was not recognized as a valid DateTime

22

So when you are inside for each row : row(“Date/Time”).tostring gives the particular cell value only.

23

Hi @VirajN,

Refer the below workflow

Main (25).xaml (9.0 KB)

After going through the excel file the String is “05/18/2019 08:30:09”
So the format of above should be “MM/dd/yyyy hh:mm:ss”

1 Like
24

thank you so very much @anil5 you cleared this one concept for me :slight_smile:

the challenge was that in the original post you missed out on the seconds in the expression and in the workflow you included that

when i modified your expression from post 3 and added ss it worked like a charm :slight_smile:

1 Like
25

That’s why understanding the expression and each parameter of that expression is more important first, rather than just saying its not working and should dig more why you are getting the error and work on that.

1 Like
26

Tq bro

27

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