>Hi,
>
>The company I work for decided to choose a single date format for all company document and software.
>
>They came up with dd-mmm-yyyy format.
>
>Is there a way to capture a date in a textbox in this format.
>
>So far I've tried this approach without any success
>
>SET SYSFORMATS ON
>SET DATE SHORT
>SET MARK TO '-'
>
>When I use ? DATE() the output is OK but when I capture a date field I still get the dd-mm-yyyy format.
>
>
>Any solution is welcome.

SET DATE DMY will give you 17/05/2004. However, to display it in a text box the with the month name then you'd have to use something like

TRANSFORM(DAY(DATE())) + "-" +;
   LEFT(CMONTH(DATE())) +;
 '-' + TRANSFORM(YEAR(DATE())).

How dates are formatted depends on the user's setting in the control panel under Regional Settings.