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
