Talking about formatting the Month, Instead of having 01,02,03 and co cant i have a way to convert to like January, February, March and so on… Using something like this;
ADD Load * Inline [ MONTH_NO, MONTH_NAME 01, ‘January’ 02, ‘February’ ] ;
Any suggestion as this is not working
Hi, haven´t tried it myself but googling these sort of questions always gives good hints how it could be solved:
let me know if it works! Cheers, Eva
Hello @EvaS,
This works very Fine, SELECT MONTHNAME() AS “Month Name” FROM WHERE
For Example; MONTHNAME(tabSales Invoice Item.modified) AS MonthS
tabSales Invoice Item
And it works very fine.