SAP Lumira Date format issue, MMM.yyyy

Hi everyone,

I have a situation where I'm using flatfile data (*.csv) which is in a monthly format (MMM.yyyy).

When loading the data into Lumira, I have the option of choosing said format for the data. However, once the data is imported into Lumira, the tool does not recognize my date column as a date, and thinks it's a string value. From the context menu I'm able to choose "Convert to Date" but the resulting data format list does not have the "MMM.yyyy" option.

I've tried using a calculated dimension to split the string into several different columns which I could maybe then use to trick Lumira into converting these columns into months and years, but this hasn't worked.

Any ideas on how to get Lumira to understand this dateformat? Similarly I've noticed that ddMMyyyy is also not supported 😔

Regards,
Karri