day of week

If your want to dispaly this in a textbox on a form or report, in the format
property of the textbox type ddd.


"John" <john@nospam.infovis.co.uk> wrote in message
news:40d56746$0$1183$cc9e4d1f@news.dial.pipex.com. ..[color=blue]
> Hi
>
> How can I calculate a three letter day of week (Mon, Tue, Wed etc.) from a
> date?
>
> Thanks
>
> Regards
>
>[/color]

Hi John,

Try:
Format([YourDate],"ddd")

HTH,
Don

"John" <john@nospam.infovis.co.uk> wrote in message
news:40d56746$0$1183$cc9e4d1f@news.dial.pipex.com. ..[color=blue]
> Hi
>
> How can I calculate a three letter day of week (Mon, Tue, Wed etc.) from a
> date?
>
> Thanks
>
> Regards
>
>[/color]