Field Type Date Time missing seconds

  • Resolved denba

    (@denba)


    1 year, 8 months ago

    Hello,

    I am currently using the Date Time field type, but I noticed that there is no option to input seconds (HH:MM:SS. I need the ability to input time in the HH:MM format for my project. Could you please suggest a workaround for including seconds in the time field?

    Thank you for your support!

    Best regards,

    Dennis

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    1 year, 8 months ago

    Hello @denba

    In the current plugin version, it would require to customize your plugin copy, or emulate the time component with dropdown fields. The plugin includes multiple alternatives to distribute the fields in columns. Please watch the following video:

    https://youtu.be/NSac2cAN8RE

    For example, assuming that fieldname1 is a date field, fieldname2 is a dropdown list for hours, fieldname3 is another dropdown list for minutes, and fieldname4 is a third dropdown field for seconds.

    As part of the equation you can include the piece of code:

    let d = CONCATENATE(CDATE(fieldname1, 'yyyy/mm/dd'), ' ', fieldname2|r, ':', fieldname3|r, ':', fieldname4|r);

    Now the d variable contains a text with the format “yyyy/mm/dd hh:ii:ss” and you can use it with the Date/Time operations:

    https://cff.dwbooster.com/documentation#datetime-module

    Best regards.

    Thread Starter denba

    (@denba)

    1 year, 7 months ago

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Field Type Date Time missing seconds’ is closed to new replies.