Format attributes for Glide Date fields?

[jim pisello]

We're adding a custom date field to the cmdb_ci table. Rather than using the date format set in the system properties, we'd like the date in this field to be expressed as Quarter/Year, as in Q1 2011, Q4 2012, etc. This is obviously a special exception to the standard date format we're using (yyyy-MM-dd). I was hoping to find a format attribute that could be applied to the field's dictionary entry in order to change the input format, while still storing the date in the system default format.

[john_roberts]

There's no attribute that would handle this. If it's for display only the next best option is to create a new field to store the string format you want, then have a business rule calculate the display string whenever the date field changes. If you want to use the field as input you can use a string field and a client script to validate the input value is in the correct format.

[kalyan778]

Hi John,

Can you please share the script for this.

Thanks,

Kalyan

[jim pisello]

Thanks John. I assumed as much but thought I'd check. Appreciate the quick response.