DateToText(Today) question?

[macaroni]

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.

[Lee Smith]

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

[slstrother]

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)

[SteveB]

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