Feliz navidad y próspero año nuevo a todos los usuarios DP's
happy christmas and prosperous new year to all dp community
best regards
PD.
my whishes for pope Noel, please comminicate with Lew and release dp for
windows
Juan Antonio Salhus
De: Robert Pollard <[email protected]>
Para: [email protected]
Enviado: martes 20 de diciembre de 2011 18:16
Asunto: Re: [Dataperf] Formula
Tony
The numeric value of the date field is equal to the number of days from the
earliest admissible date, March 2, 1900 - where the G value of the date = 1.
The highest acceptable date in DP is Dec 31, 2078 - with the value of 65,319,
somewhat less than 2**16 (65,536) - so in theory. the highest date could have
been August 7, 2079. I suppose there is a good reason for that, Lew.
Happy holidays
Robert
Robert Pollard
Information Ecologist
G+ j.mp/rpollard
twitter.com/climatechange3
[email protected]
1.212.864.3156
2011/12/20 Tony Perez <[email protected]>
Gerard,
>
>Thanks for the reply.
>
>For some reason, I thought the year limitation in DP was 2052. This makes some
>sense because it ends in an even number.
>
>I believe endings in an odd number do not make sense in the binary world.
>
>In any case, it might muster up some discussion activity in the group so we
>can all wish each other a very Merry Christmas and a very Prosperous 2012 …
>the year the Mayan calendar ends … they were binary way back then when they
>developed the concept of the ZERO number and started their calendar!!
>
>All the best to all,
>Tony.
>
>From:[email protected] [mailto:[email protected]]
>On Behalf Of Gerard van Loenhout
>Sent: Tuesday, December 20, 2011 5:06 AM
>
>To: [email protected]
>Subject: Re: [Dataperf] Formula
>
>Tony, in my DP it is. I guess in yours too.
>
>Gerard
>
>
>2011/12/20 Tony Perez <[email protected]>
>What is the well known year 2079? … is that a DP limitation? … or an elsewhere
>one?
>
>From:[email protected] [mailto:[email protected]]
>On Behalf Of Gerard van Loenhout
>Sent: Tuesday, December 20, 2011 12:05 AM
>
>To: [email protected]
>Subject: Re: [Dataperf] Formula
>
>Brian, the second one worked. We're happy.
>The first option gave the well known year 2079.
>
>Thanks to Robert and Juan as well for your efforts.
>
>Gerard
>
>2011/12/20 Brian Hancock <[email protected]>
>As an alternative you could try this. It use the Print indicator to strip
>blanks, and you can use a blank as the date component separator
>
>truncate[apply.format["DDMY99 99 9999;;D";P1F1]] " "
>truncate[apply.format["THMS99 99;;D";P1F2]]
>
>Regards
>Brian
>
>
>
>________________________________
>
>From:[email protected] [mailto:[email protected]]
>On Behalf Of Robert Pollard
>Sent: Tuesday, 20 December 2011 8:50 AM
>To: [email protected]
>Subject: Re: [Dataperf] Formula
>
>Gerard
>
>Sorry about that; I tried a shortcut without testing it. You're right, Juan
>Antonio. Should look like this now:
>
>cat.t[ apply.format [ "DDMY99" ; P1F1 ] ; apply.format [ "DMDY99" ; P1F1 ]
>; apply.format [ "DYMD9999" ; P1F1 ] ; apply.format[ "THMS99" ; P1F2 ] ;
>apply.format[ "TMHS99" ; P1F2 ] ]
>
>Robert
>
>2011/12/19 Juan A. Salhus R. <[email protected]>
>Gerard, you must cat[and apply format the date field to field eg.
>datemonthyear
>Juan Antonio
>
>
>________________________________
>
>De:Gerard van Loenhout <[email protected]>
>Para: [email protected]
>Enviado: lunes 19 de diciembre de 2011 16:19
>Asunto: Re: [Dataperf] Formula
>
>Chris, I'm afraid it doesnt work'.
>
>A date 27-02-2004 14:00 comes out like:
>
>00000027 HM0014
>
>
>Gerard
>
>2011/12/19 Robert Pollard <[email protected]>
>Gerard
>
>I think this should work, where P1F1 is the date field and P1F2 the time field:
>
>cat.t[ apply.format [ "DDMY99999999" ; P1F1 ] ; apply.format[ "THM9999" ; P1F2
>] ]
>
>Robert
>
>2011/12/19 Gerard van Loenhout <[email protected]>
>Dear all, I need some help with a formula.
>
>I need to have a string in a text field. The data comes from a date and a time
>field
>
>08-12-2009 11:44
>
>Which is a date field (day-month-year) and a time field
>
>And as you can see we do not put the year first in a date field.
>
>
>It should come out in a report like this: 08122009 1144
>
>Is that possible? Without the ' - ' and the ' : '
>
>
>Regards
>
>Gerard van Loenhout
>
>
>
>_______________________________________________
>Dataperf mailing list
>[email protected]
>http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
>
>_______________________________________________
>Dataperf mailing list
>[email protected]
>http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
>_______________________________________________
>Dataperf mailing list
>[email protected]
>http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
