date issue

[DanielCarro]

Hi guys,

In the attached, I am trying to extract the date from column C but for some reason it is just extracting the first row. 

I tried in formula DateTimeParse and DateTimeFormat, and really nothing happens. I didn't want to really trim the left.

Regards,

Dan

[aatalai · Accepted solution]

@DanielCarro take a look a the attached workflow that should do the trick. let me know how you get on 

[DanielCarro]

Hi @aatalai , it worked fantastic. I didn't take into account the time. Thank you