Manage DateTime in Corredor Script

Hi All,

it’s me again, this time i’m facing some issue managing a DateTime record field in the Corredor script, let me explain.

Some external Webhook trigger my workflow that parse the request body and pass it to a script, now inside my js code i’ve an object that has a Date in a string format (aaaa-mm-dd) and i want to store it inside my record, so i’m using a record field of type DateTime.

this is the snippet i’m using to “convert” the string into a DateTime object

customer.values.dob = new Date(args.dob)

the script does not block during execution so i’m assuming that the record creation is succeded but in my record page i can’t see the value in the field and if try to print using another workflow that search a record and print the value of Date i’ve got an error stating that there’s an interface error

format(“DoB → %v”, user.values.dob)" failed: expected type interface {} for parameter 1 but got <nil>

Does new Date(args.dob) return a valid Date? Try console.log over the value to see what it prints out.

If I recall correctly, passing a Date object into a date time field should work. If not, try to convert it into the ISO 8601 string format (I forgot what the function is called but I know the Date object has one)

this is the console.log of the record value just after the assignment


 customer.values.dob = new Date(args.dob)

 console.log('dob -> ',customer.values.dob)

Log in the terminal

dob ->  1976-10-02T00:00:00.000Z

everything look like it worked but in the page the field is empty :upside_down_face:

Does it go through if you convert the date object into the iso string?
Can you show how the module field is configured?
What version are you on?

i’m on the 2022.3.2
here’s a snapshot of the module field, i haven’t done other configuration

regarding the isoString conversion idk how to do it and test it

This is a console.log of what i get in the req Body

args -> 1976-10-02
Type :  string

i’ve done some test using this reference
and the type of the value is a Date object, so i think there’s something like a validation on corteza server that erase the record or so

This are all of the supported formats – corteza-server/sanitizer.go at 2022.9.x · cortezaproject/corteza-server · GitHub

I can’t remember what happens to the Date object when it gets sent over the network; it’s probably getting converted to some strange string which we can’t parse. You can change it to an ISO like so: Date.prototype.toISOString() - JavaScript | MDN

Thanks, i’ll try asap

do i need to change the record field type to String ? or under the hood the server do something like a Date.parse ? EDIT → NO

EDIT. It Works !

1 Like