How to set "Date-Time Picker" custom field with current date-time

[Shalev Utnik]

Hello,

I'm trying to set a date to a date-time filed using "Mathematical or date-time expression calculator"

I want to store in the filed the current time how can I do it?

Thanks!

[Fidel Castro Armario]

Hi Shalev,

Glad to have news from you. I hope you are well.

I show you how to do it using an example: Let's suppose we want to set a "Date Time Picker" custom field called "My Date" with current date-time. To do it you have to use "Mathematical or date-time expression calculator" with the following configuration:

Note that {00057} is field code for "Current date and time".

Best regards,

Fidel

[Shalev Utnik]

Great, so simple :)

[Shalev Utnik]

one more followup question: is there an option to set this field only if it's empty?

[Fidel Castro Armario]

Yes, use the following expression:

{nnnnn} = null ? {00057} : {nnnnn}

where {nnnnn} is the field code of target field.

[Shalev Utnik]

Thanks Fidel. I did it and got:

Field Solution Provided will be assigned with the calculation result of the formula: {12303} = null ? {00057} : {12303} :: PARSE ERROR : Encountered " "=" "= "" at line 1, column 9. Was expecting one of: "+" ... "-" ... "*" ... "/" ...

What am I missing?

[Fidel Castro Armario]

Which version of the plugin are you using?

[Shalev Utnik]

2.1.19

[Fidel Castro Armario]

It doesn't work because conditional operator ? : is not implemented in that version. You should update.

[Shalev Utnik]

Yep, works well after upgrade.

Thanks!