LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  adjust time by a different field

    Employee
    Posted 10-15-2015 17:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: tekaleka

    Hi,

    I want to adjust the 'startTime' filed with the 'duration' field so i can get the 'endTime'.Sample data is shown below.Any sugestions??

    duration startTtime
    10 2015-08-26 10:00:28
    18 2015-08-26 10:00:28
    25 2015-08-26 10:00:35

    regards.


  • 2.  RE: adjust time by a different field

    Employee
    Posted 10-15-2015 17:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    Something like this (copy the following and paste onto the Lavastorm canvas):

    node:Calc_End_Time
    bretype:core::Filter
    editor:Label=Calc End Time
    editor:sortkey=56204c0b063e1ee7
    input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
    output:@40fd2c7420761db6/=
    prop:Script=<<EOX
    endTime = startTime.dateTimeAdjust(duration,"minutes")
    emit *,endTime

    EOX
    editor:XY=280,180
    end:Calc_End_Time

    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=56204be66ee92e19
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    duration:int,startTime:datetime
    10,2015-08-26 10:00:28
    18,2015-08-26 10:00:28
    25,2015-08-26 10:00:35
    EOX
    editor:XY=140,180
    end:Static_Data


  • 3.  RE: adjust time by a different field

    Employee
    Posted 10-15-2015 18:16

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: tekaleka

    thank you!!