Skip to main content

Derived Field - Extract Time Part

Comments

1 comment

  • Glyn McKenna

    Hi Dishaa,

    This is the Logi Info forum, so your question should be on the Logi Composer platform forum really, however the extract syntax should be as follows:

    extract('year', begin_date)

    The error is complaining that your start_date field is a string though. You might be able to use the text_to_time function eg:

    extract('year', text_to_time(begin_date, 'MM/dd/yyyy'))

    ...But it may be better to make it a proper datetime field in the database

    0

Please sign in to leave a comment.