TextToDate Problem - please help!

[edelweissa]

In South Africa we use the date format dd/mm/yyyy. In order to do sorts in FM I need to change this format. I have managed to change the date to mm/dd/yyyy using a calculation. I can, however, only display the result as a text field. If I try to use TextToDate and change the field type to a date field, it displays nothing. I even tried to do the conversion first (as a text field) then do the TextToDate as a new calculation into a third field. It still displays nothing. Can anyone please help!!

[Kurt Knippel]

quote:

---

Originally posted by Edelweiss:

In South Africa we use the date format dd/mm/yyyy. In order to do sorts in FM I need to change this format. I have managed to change the date to mm/dd/yyyy using a calculation. I can, however, only display the result as a text field. If I try to use TextToDate and change the field type to a date field, it displays nothing. I even tried to do the conversion first (as a text field) then do the TextToDate as a new calculation into a third field. It still displays nothing. Can anyone please help!!

---

On your layout you can format the dates in anyway you wish. Look at the formatting options for date fields.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=