Time Comparison in BPM

Yahoo Archive
1
Thanks, This helps.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, April 25, 2012 3:52 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Time Comparison in BPM

Null datetimes in progress are usually specified with a question mark. That
said, clock in/out times are stored as decimals and default to 0.
Also, if you want to find records where the user did not clock out, you can
just search for records where 'ActiveTrans = True'. That will return
anything that is currently clocked in. To add 3 hours to the clock in time
just add '3' to it --don't forget to set activetrans as false. Should look
something like this:

FOR EACH LaborHed WHERE LaborHed.ActiveTrans = True:
ASSIGN LaborHed.ClockOutTime = LaborHed.ClockInTime + 3
LaborHed.ActiveTrans = FALSE.
END.

On Wed, Apr 25, 2012 at 3:42 PM, mike.numbers <mnumbers@...> wrote:

> **
>
>
> I am trying to write a BPM that will compare the clock out time to see
> if there was an entry and if not, add 3 hours to the clock in time to
> be the clock out time. I have 2 problems that I know of, 1- I can't
> seem to figure out the syntax to compare the original clock out time
> to see if any value is already there. I have tried
> ttLaborDtl.ClockOutTime = 0 and ttLaborDtl.ClockOutTime = '24:00:00'.
> Neither of these worked. Any idea what this format should be. My
> second problem is what is the syntax I need to add 3 hours to the
ClockInDate to get a ClockOutDate.
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
I am trying to write a BPM that will compare the clock out time to see if there was an entry and if not, add 3 hours to the clock in time to be the clock out time. I have 2 problems that I know of, 1- I can't seem to figure out the syntax to compare the original clock out time to see if any value is already there. I have tried ttLaborDtl.ClockOutTime = 0 and ttLaborDtl.ClockOutTime = '24:00:00'. Neither of these worked. Any idea what this format should be. My second problem is what is the syntax I need to add 3 hours to the ClockInDate to get a ClockOutDate.
3
Null datetimes in progress are usually specified with a question mark. That
said, clock in/out times are stored as decimals and default to 0.
Also, if you want to find records where the user did not clock out, you can
just search for records where 'ActiveTrans = True'. That will return
anything that is currently clocked in. To add 3 hours to the clock in time
just add '3' to it --don't forget to set activetrans as false. Should look
something like this:

FOR EACH LaborHed WHERE LaborHed.ActiveTrans = True:
ASSIGN LaborHed.ClockOutTime = LaborHed.ClockInTime + 3
LaborHed.ActiveTrans = FALSE.
END.

On Wed, Apr 25, 2012 at 3:42 PM, mike.numbers <mnumbers@...> wrote:

> **
>
>
> I am trying to write a BPM that will compare the clock out time to see if
> there was an entry and if not, add 3 hours to the clock in time to be the
> clock out time. I have 2 problems that I know of, 1- I can't seem to figure
> out the syntax to compare the original clock out time to see if any value
> is already there. I have tried ttLaborDtl.ClockOutTime = 0 and
> ttLaborDtl.ClockOutTime = '24:00:00'. Neither of these worked. Any idea
> what this format should be. My second problem is what is the syntax I need
> to add 3 hours to the ClockInDate to get a ClockOutDate.
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]