OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums Forums OroCRM OroCRM – Programming Questions limit of time format

This topic contains 3 replies, has 3 voices, and was last updated by  ypetrov 4 years, 5 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #25460

    golriz.nourani
    Participant

    Dears

    I used time format of oro in datagrid but for all times more than 838:58:58 , data is 838:58:58
    could you help me?
    Thanks
    Golriz

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
    Replies
  • #25461

    msulima
    Moderator

    Hi, golriz.nourani.
    Please, provide an example of data using. What type of datagrid field you use?


    #25462

    golriz.nourani
    Participant

    Hi,msulima
    my code is below

    select:
    -TIMEDIFF(max(v.outTime),min(v.inTime) )) as totalduration
    .
    .
    .
    columns:
    totalduration:
    label: orocrm.visit.total_durattion
    frontend_type: time

    #25463

    ypetrov
    Participant

    Hello golriz.nourani.
    As far doctrine don’t have much functions to works with dates, I would advice such solution:
    1)

    2)

    3)

    I leave {{ dump() }} just to show that result will be \DateInterval so you should decide what to do next, hope approach is clear.

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

The forum ‘OroCRM – Programming Questions’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No