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
