Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to force ALLCAPS in Date/Time Field

Avatar

Level 1

I have searched in google for this and i found this

     // Current Date in MMM DD, YYYY style in uppercase.

     $.rawValue = Upper(num2date(date(), "DDMMMYY"))

but i don't want the current date, i want the date i select in the Date/Time Field.

i tried this but it didn't work

    $.rawValue = Upper($.rawValue)

can someone help me?

1 Accepted Solution

Avatar

Correct answer by
Level 7

In the exit event for the date/time field put (in Formcalc):

$ = Upper($.formattedValue)

just make usre you have specified the dsiplay pattern you want in the object palette.

View solution in original post

0 Replies

Avatar

Correct answer by
Level 7

In the exit event for the date/time field put (in Formcalc):

$ = Upper($.formattedValue)

just make usre you have specified the dsiplay pattern you want in the object palette.

Avatar

Level 10

Hi,

It depends on the language you are using: JavaScript or FormCalc in the Script Editor.

Upper is a FormCalc function, but .rawValue is JavaScript.

So if FormCalc try this in the exit event:

$ = Upper($);

if JavaScript try this in the exit event:

this.rawValue = this.rawValue.toUpperCase();

Hope that helps,

Niall

Good catch by whyisthisme, you probably have to use the Upper function on the formatted value.

Message was edited by: Niall O\'Donovan

Avatar

Level 10

Yeah, those don't work on the date field - I was trying to figure it out but didn't think of trying the formattedValue!

Avatar

Level 10

Yeah Jono,

this.rawValue = this.formattedValue.toUpperCase();

...works!

Niall

Avatar

Level 1

thanks to everybody

     Formcalc:

               

Works -->          $ = Upper($.formattedValue)

     Javascript

    

Works -->          this.rawValue = this.formattedValue.toUpperCase();

once again thank you

Avatar

Level 2

This works great but the date validation fails with this code in there (either formcalc or java) . I even took away all the validation filters and it still fails. This is annoying.

I just want an upper case MONTH YEAR that will pass without an error off a date drop down or user entry.

Thank you if anyone has a solution.

Avatar

Level 2

This looks like a valid solution for a single field/value, but is there an easier way to force ALL field values on a form to be uppercase? Perhaps at the form or master page level? I'd prefer not to have to add uppercase script to each field on my form, if possible.