Date issue

[Carlyn]

Hi

I have a file that is received with 2 different formats in the Match Date column. When I use Date/Time 1 format updates fine and presents as I would expect it to and the other format returns [Null]. I have tried adding in the following formulas but neither are working:

todatetime(DateTimeParse([Match Date],'%m/%d/%y %I:%M %P'))

DateTimeFormat([Match Date], "%m/%d/%Y")

I have attached the workflow.

Can anyone please suggest how I can format the 2 different formats to give me 1 column with the date?

[Deano478]

@Carlyn can you upload the data file aswell or maybe just copy and paste some of it here as we cant access the file on your machine

[Raj]

@Carlyn you have nit added the input file.

[Carlyn]

Sorry - meant to add the additional files, I have edited and added now.

[Raj]

@Carlyn 
use this formula to original input
IF Contains([Match Date], "/") THEN
DateTimeFormat(DateTimeParse([Match Date], "%m/%d/%Y %I:%M:%S %p"), "%Y-%m-%d %H:%M:%S")
ELSE
DateTimeFormat(DateTimeParse([Match Date], "%Y-%m-%d %H:%M:%S"), "%Y-%m-%d %H:%M:%S")
ENDIF

mark done if solved.

[Carlyn]

Thank you for your response. However, it is still not quite right. Attached is some data to show the problem. You will see that on the original data, although the formatting in the Match Date column appears to be slightly different, all four of these rows are reflecting June dates. But my output is reflecting the first item as an October date when it completes. Any suggestion on what I need to do to fix this?