Date formating

[overrider]

Hello all,

can someone tell me how to convert a Date like this 2005-9-13 into this 09/13/2005 so Filemaker will accept it in a Date Field? Thanks a lot...

[Søren Dyhr]

Faster typecasts might exist, but this one works to an extend:

Middle ( entryAsText ; 6 ; 5 ) & "-" & Left ( entryAsText ; 4 )

...then format the datefield to use slashes.

--sd

[overrider]

hey thanks, that worked