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
