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

[Former Member]

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.

[abhilash_kumar · Accepted solution]

Hi,

Try:

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

-Abhilash

[Former Member]

thanks Abhilash.