This may be a stupid question but for some reason, when I use DateToText(Today)

it returns 6/20/2003. You might ask, what is wrong with this but it said in the filemaker pro bible that it would return in the format 06/20/2003. of the format MM/DD/YYYY, having a "0" before single digit numbers for the month and day. This is the exact format that I would like it to be in.

Is there a preference that I need to change?

Thanks.

It will show that way, if you select that formatting in Layout mode. Go to Layout Mode, select the field, go to Menu - Format - Date and Play with the options, you will find several ways to display your date field

Lee

DateToText will drop the leading zeros. If you need them in your text field, you will need to add them via calculation.

Right("0"&Month(Today),2)&"/"&Right("0"&Day(Today),2)&"/"&Year(Today)

Do not use Today...instead use Status(CurrentDate). It's faster and it's always correct. If your datafile remains open past midnight, Today will still indicate 'yesterday'.

Steve