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
