Convert 'now' value to dateFormat in Transform rule

Hi,

I would like convert now value in formar mm/dd/yyyy
for this, I’m using the following rule, but this code does not work

{
	"attributes": {
		"input": "now",
		"inputFormat": "ISO8601",
		"outputFormat": "PEOPLE_SOFT"
	},
	"type": "dateFormat"
	"id": "Test Transform"
}

So, my question is, Is it possible convert now value to format PEOPLE_SOFT? what is the best way to convert this value?

Thanks in advance

Hi – please try this transform - I believe this will work:

{
    "attributes": {
        "input": {
            "attributes": {
                "input": "",
                "expression": "now"
            },
            "type": "dateMath"
        },
        "inputFormat": "yyyy-MM-dd'T'HH:mm",
        "outputFormat": "PEOPLE_SOFT"
    },
    "type": "dateFormat",
    "id": "Test Transform"
}
3 Likes

Hi @lisa.ivy

The rule works!

Thanks for you help

2 Likes