Thanks ....it worked........Thanks Sent from my Cellular South Galaxy S
Walter381 <[email protected]> wrote: >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 _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
