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

Issue #138 resolved
Shalev Utnik created an issue

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!

Comments (13)

  1. Fidel Castro Armario repo owner

    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:

    conf-1.png

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

    Best regards,

    Fidel

  2. Fidel Castro Armario repo owner

    Yes, use the following expression:

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

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

  3. Shalev Utnik reporter

    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?

  4. Fidel Castro Armario repo owner

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

  5. Log in to comment