Convert date

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

And it works very fine.

1 Like