I am not sure if there is a better way to deal with this issue, but I found 2 methods that will deliver date columns in a recognizable way to AO and Lumira. The first is to join your table with a calendar view such as FiscalCalendar, and to use the Date_E column as the date output. If you have one date to output, this method can work, but if you have many date fields to output, then the next method will be the better way to do it.
The second method is to create a new calculated column of Date type, and use the formula “date(leftstr(<Date Field>,4)+ '/' + midstr(<Date Field>,5,2)+'/'+ rightstr(<Date Field>,2))” to create a formatted Date field. Now AO and Lumira will recognize it as dates. I hope SAP figures out a way for AO and Lumira to automatically recognize dates in the future.
Add comment