Re: converting a date?

Alternately,

Let ( [

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

Date ( MoNum ; Da ; Yr ) )

That's what I love about FileMaker. There are so many ways to do something.

Matt

Matt Wills wrote:
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: Help with GetNthRecord Custom Function
    ... What you have for that line near the end is correct assuming you have changed the function name top GetNthRecordSet and removed the fourth parameter from the definition of four parameters up top. ... Frankly, I had no idea what to do with Functions, so each time that FileMaker proclaimed that it couldn't find a function, I just added it as a function. ... I am so green with custom functions that I do not know how to get past even this simple error of missing an operator. ... Associate Member, FileMaker Solutions Alliance ...
    (comp.databases.filemaker)
  • Re: back after a long time with some questions...
    ... to say you get a dev license for it? ... Lists all the features in FM8A above and beyond what you get with FileMaker ... Custom functions, functions which can be re-used anywhere in your ... Ability to copy and paste fields, tables, scripts, and script steps. ...
    (comp.databases.filemaker)
  • Re: back after a long time with some questions...
    ... Lists all the features in FM8A above and beyond what you get with FileMaker ... Custom functions, functions which can be re-used anywhere in your ... Ability to copy and paste fields, tables, scripts, and script steps. ...
    (comp.databases.filemaker)
  • Re: Can a calculation pick up content from multiple related records
    ... you can use Custom Functions to build your own. ... a portal to a related table that contains family members and their contact info. ... FileMaker 8 Certified Developer ... Associate Member, FileMaker Solutions Alliance ...
    (comp.databases.filemaker)
  • Re: Complex Relationship help needed
    ... Brian Dunning's site is now back up and I found that my proposed search criteria didn't get any results. ... Though defined custom functions will work in any version of FM7/8, you may only create them using FM Developer 7 or FM Pro Advanced 8. ... If you don't have these versions of FileMaker, then you cannot create custom functions. ... Of the following three calcs, the only one that doesn't use recursion is RemoveByValueList, which means you should be able to use the same calc as just a regular calc field instead of a custom function. ...
    (comp.databases.filemaker)