Issue with a date time variable

[Sonia]

Hi, having bit of trouble with a data time variable, my datapill is in this format: 2026-01-29T06:01:28.000000-05:00 and using all possible hints from AI to convert it to YYYY-MM-DD HH:MM but it just returns: Error calculating input for field 'date':
wrong number of arguments (given 1
expected 0)

I'm only just starting my journey with workato

[francbaviello]

Hi @Sonia , this is the correct solution formula:

="2026-01-29T06:01:28.000000-05:00".to_time.strftime("%Y-%m-%d %H:%M")

where "2026-01-29T06:01:28.000000-05:00" is the value of field datapill

[gary1]

This is the way.