Re: converting a date?

This would do it, either as a separate calc field or as Replace Field Contents:

Date =

Let (

[ Da = Left ( YourDateText ; Position ( YourDateText ; "-" ; 1 ; 1 ) - 1 ) ;
Mo = Middle ( YourDateText ; Position ( YourDateText ; "-" ; 1 ; 1 ) + 1 ; 3 ) ;
Yr = Right ( YourDateText ; 2 ) ;
MoNum = Position ( " JanFebMarAprMayJunJulAugSepOctNovDec" ; Mo ; 1 ; 1 ) / 3 ] ;

MoNum & "/" & Da & "/" & Yr )

Matt

bobw@xxxxxxxxxxx wrote:
someone entered all dates in a text field in the format, "29-Sep-07"

How do I convert them all to standard FM date format, "09/29/2007"?

There are about 500 records covering several months' worth of dates.


--
Free FileMaker Technique Demos: http://www.VirtualVermont.com/FMP

My Custom Functions: http://www.briandunning.com/filemaker-custom-functions/results.php?keyword=wills
.

Relevant Pages

  • Re: converting a date?
    ... Helpful Harry wrote: ... There are about 500 records covering several months' worth of dates. ... either as a separate calc field or as Replace Field Contents: ...
    (comp.databases.filemaker)
  • Re: converting a date?
    ... There are about 500 records covering several months' worth of dates. ... either as a separate calc field or as Replace Field ... In Matt's custom function you only need to change the last line from: ...
    (comp.databases.filemaker)