Date&Time Manipulation

[Gabriel2020]

Good morning people, everything fine ?

I’m having trouble performing a filter based on the date and this is because I can’t transform a string into a date and time format. I’m going to send some photos below and I hope they can help me.

[HansS]

Hi @Gabriel2020

It looks like your DateFormat should be: MM/dd/yyyy
gr. Hans

[Gabriel2020]

@HansS

It looks like your DateFormat should be: MM/dd/yyyy
gr. Hans

Good morning Hands, how are you?

The error keeps giving the same.

[HansS]

Hi @Gabriel2020

Did you check Row: Row456_Row161 there maybe some data the Format node doesn’t understand. Some special characters or otherwise…?

gr. Hans

[Gabriel2020]

I checked and apparently the only change would be that it goes from month 3 to month 2, I think maybe with the no sorter I should solve it

[Gabriel2020]

Did not work. Do you know any way for him to identify what the year, month and day would be and then I can organize it. I create these columns.

[morpheus]

Hi @Gabriel2020 ,
if take the specific row in account you can identify format which is dd/MM/yyyy.

BR

[Gabriel2020]

Thanks guys, I managed to solve it. I needed to change to yyyy-MM-dd Format using string manipulation