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
