Date Field Format

[Kasey]

I have a rule that on change of a date field {ReleaseDate} I set the field value of the {Title} to include the date. By default it is formatted as 6/25/2020 but I’d like it to be June 25, 2020. I tried {ReleaseDate[dddd MMMM dd, yyyy]} but that doesn’t seem to work. Is this possible out of the box?

[Amal Vellappillil]

try this

{ReleaseDate['MMMM dd, yyyy']}

[Alexander Bautz]

Hi,
Sorry, but the Set field value in the rules don’t support that. You must call a custom function like this from the rule:

function setFormattedDate(){
    var dateObj = spjs.utility.getDateFieldAsDateObject("DateColumn1");
    setFieldValue("Title",spjs.dffs.formatDate(dateObj,"dd MMMM yyyy"));   
}

Change DateColumn1 to match your date field name.

Alexander

[Author]

Posts