Converting text to date format

Question
1

Hello, I have received a budget-related file with column headers such as apr-2024, may-2024, and so forth. To effectively analyze the file, I require the conversion of these headers into a date format (as the date format transform does not function with text), for example, 04/01/2024, 05/01/2024, and so on. I intend to use the Gather transform for this purpose and subsequently utilize the transformed data in another program as dates. Do you have any suggestions or ideas regarding this process?

Thank you,
Miguel

2

Gather is probably the best way to move months from the header. You can use Spread to move them back again.

DateTime Format does handle month names as well as month numbers.

https://www.easydatatransform.com/help/latest/windows/html/index.html?date_format.html

The month names recognized depends on the locale set in Preferences.

image
image762×1214 81.2 KB