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
