Hi Duncan,

We did not support that formula yet in latest release;

As for your case, I think it could be done with custom script like this:

Suppose the Invoice_Date field is a date field and you would like the value to be put on a single line field, then add "date1" as CSS class to the date field and "date2" as CSS class to the single line field, and add custom script:

$(document).ready(function(){
  $('.date1 input').on('change', function(){
    var dateValue = $('.date1 input').val();
    var dateFormat = $('.date1 input').attr('momentpattern');
    var dateUpdated = moment(dateValue, dateFormat).format('MMM yyyy');
    $('.date2 input').val(dateUpdated);
  });
});

It worked like this:

Hi Rui, that's an excellent workaround, thanks!

I have made the changes - however we are seeing some difference and it's not quite working:

So for some reason it's not grabbing the year correctly - although the month is fine.

You can probably see that we are using dd/MM/yyyy format for our dates (being in NZ) so I wondered if that could that be the issue; but changing the Invoice Date format made no difference.

The code has been copy/pasted exactly as you have it in your example.

Any ideas why it might not be grabbing the year correctly?

Thanks again!

Hi Duncan,

Can you try changing format('MMM yyyy') to format('MMM YYYY') and check if it works?

It seems that yyyy was not recognized in earlier version of Forms.