Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to convert to uppercase if database field date is string?

Using this formula and format object to just display month it's work but i need month to be uppercase.

Date({Table.Month})

This formula work but it just display format 01/12/2015, not just JULY

UpperCase(Totext(Date({Table.DateIn})))

Thanks.

Tags:
replied

Hi,

Try:

Uppercase(totext(date({string_field}), 'MMMM'))

-Abhilash

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question