Thanks...for your help Sent from my Cellular South Galaxy S
Brian Hancock <[email protected]> wrote: >Happy New Year Walter, > > > >I suspect that your input file has 2-digit years, and so DP interprets them >in various ways. I think, but not sure with the limited information about >the file you are importing etc, that if you enter the definer mode for the >panel and select the data field press Shift F8 for the Field Option and Item >8, allows you to set a rollover year, so you can manage what are 2000 dates >and what are 1900 date, its not perfect and every year that passes it gets >less perfect as any years before 00 and the current year, now almost 2012, >will be still ambiguous > But I think it will solve or alleviate your >problem. > > > >Regards > >Brian > > > > > > _____ > >From: [email protected] >[mailto:[email protected]] On Behalf Of walter watson >Sent: Saturday, 31 December 2011 4:56 PM >To: [email protected] >Subject: Re: [Dataperf] Formula > > > >HI GUYS --- I GOT A PROBLEM ---- WHEN I IMPORT DATES ---- THEY(THE DATES) >CHANGE FROM 2000'S TO 1900'S---------------------- >HOW CAN I IMPORT 2011'S DATES ---- IT BE 2011'S DATES------------WHAT CAN I >DO---------------HELP----------------------------------- >THANKS >WALTER > > _____ > >Date: Fri, 23 Dec 2011 15:17:55 +0000 >From: [email protected] >To: [email protected] >Subject: Re: [Dataperf] Formula > >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 > > >_______________________________________________ >Dataperf mailing list >[email protected] >http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
