Adding a default date value of ‘use current date’ when creating a data extension via WSProxy

Question

I’m trying a default date value of ‘use current date’ when creating a data extension via WSProxy.

I’ve tried

Now() GetDate() Current Date

Docs say Now(), another SFSE post says GetDate(); neither worked for me. The script works when I don’t set a default value for it.

Answer 1

this is curious, but it works:

"getdate()" including doubleQuotes.

    Platform.Load("Core","1");

    var prox = new Script.Util.WSProxy();
    var name = "myDE";
    var de = {
        Name: name,
        CustomerKey: name,
        Description: "",
        Fields: [
            {
                FieldType: "Text",
                Name: "Field1",
                MaxLength: 254,
                IsPrimaryKey: true,
                IsNillable: false,
                IsRequired: true
            },
            {
                FieldType: "Date",
                Name: "Field2",
                DefaultValue: "getdate()"
            }
        ]
    }

    var res = prox.createItem("DataExtension", de);
</script>