You can use the date function if you put the parameters in correct order. No matter what system settings you have, the parameters must be in this order:
Date ( $Month ; $Day ; $Year )
1 of 1 people found this helpful
Follow the advice of philmodjunk on the proper use of the Date() function.
I'll add that your field should not be named "Date" (or "Time"). That is already the name of a built-in function. You should change the field name to something different.
If you can't get the format you want from FileMaker's date formatting (e.g., you want to use the yyyy-mm-dd date as a text piece in another calculation), you can format it yourself.
$Year & "-" & $Month & "-" $Day
Thanks Phils, Tom. I will work on it tomorrow and post if it all worked (night here).
Tried it already - works! I had tried my system date format (yyyymmdd) and the European format, but didn't think of the US option :-)
Thanks again Phil.
Tom, will change names also.