Capture the month and year of a date field.

[DianneA]

I would like to capture the month and year of a date field. For example, I have a field ‘Due Date’ set to 08/17/17. I would like to capture Aug 2017 as another field.

I’m trying to use the month feature of JWT Calculated Date-Time Field but cannot get the format correct.

[Fidel Castro Armario]

Hi @darnonee,

You can set a text field with a text string like Aug 2007 using Copy a parsed text to a field post-function with the following configuration:

Text expression is: dateTimeToString({00012}, "MMM yyyy", SERVER_LANG), where {00012} is field code for Due date.

MMM yyyy is date format descriptor.

You can also use a Calculated Date-Time Field with the following configuration:

Formula:

Display Format: