RB: Date/Time conversion

Yahoo Archive
1
Thank you very much Todd. From your example I got what I needed.

Fredy Venczel


-----Original Message-----
From: Todd Caughey [SMTP:caugheyt@...]
Sent: Tuesday, March 23, 2004 12:32 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB: Date/Time conversion

Off top of head...
(TargetDate - 01/01/2004) * 1440 = Minutes from start of year to
start of TargetDate
There should be no seconds since the Day Difference should be a
whole number (days)
If you also need actual minutes/seconds since midnight to right now
then add
INTEGER(TIME() / 60) = CurMin and
TIME() - (CurMin * 60) = CurSec

I don't think RB has a "System Minutes or Seconds" function that
converts a date to minutes since an arbitrary base time like the labor
detail record stores for ClockInMinute.

-Todd C.


-----Original Message-----
From: Fredy Venczel [mailto:fvenczel@...]
Sent: Tuesday, March 23, 2004 9:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Date/Time conversion


Is there a way to convert a date field into minutes or seconds since
the
beginning of the year?

Thanks,

Fredy Venczel
2
Is there a way to convert a date field into minutes or seconds since the
beginning of the year?

Thanks,

Fredy Venczel
3
Off top of head...
(TargetDate - 01/01/2004) * 1440 = Minutes from start of year to start of TargetDate
There should be no seconds since the Day Difference should be a whole number (days)
If you also need actual minutes/seconds since midnight to right now then add
INTEGER(TIME() / 60) = CurMin and
TIME() - (CurMin * 60) = CurSec

I don't think RB has a "System Minutes or Seconds" function that converts a date to minutes since an arbitrary base time like the labor detail record stores for ClockInMinute.

-Todd C.


-----Original Message-----
From: Fredy Venczel [mailto:fvenczel@...]
Sent: Tuesday, March 23, 2004 9:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Date/Time conversion


Is there a way to convert a date field into minutes or seconds since the
beginning of the year?

Thanks,

Fredy Venczel


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/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12c43e3cq/M=268585.4521611.5694062.1261774/D=egroupweb/S=1705007183:HM/EXP=1080143705/A=1950447/R=0/SIG=1245hvqf1/*http://ashnin.com/clk/muryutaitakenattogyo?YH=4521611&yhad=1950447> click here
<http://us.adserver.yahoo.com/l?M=268585.4521611.5694062.1261774/D=egroupweb/S=:HM/A=1950447/rand=336902345>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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