Thanks it worked....... Sent from my Cellular South Galaxy S
Tim Rude <[email protected]> wrote: >Sorry to weigh in late, but... > >If you are doing the export to CSV from Excel yourself and therefore >have access to the Excel spreadsheet, it might be better to simply fix >the format in Excel so that you have a 4-digit year. Then do the export. > >That way there's no ambiguity. > >Tim Rude > >----- Original Message ----- >From: "Walter381" <[email protected]> >To: <[email protected]> >Sent: Sunday, January 01, 2012 8:26 AM >Subject: Re: [Dataperf] Formula > > >> 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 _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
