dbranch

Members

Everything posted by dbranch

Converting Month integer to Month Label (JAN)

dbranch replied to dbranch's topic in Products

Thanks..It worked like a charm
Converting Month integer to Month Label (JAN)

dbranch posted a topic in Products

I have set my SQL statement to group invoices by month by using the month function, i.e month(Date). This works fine and returns the month as an integer whenused as a field. I was wondering if anyone has written an expression to convert this integer into a month label, either as the month name or the three letter abreviation? Thanks.