day of week

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / General 1 / June 2004

day of week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 20 Jun 2004 11:28 GMT

Hi

How can I calculate a three letter day of week (Mon, Tue, Wed etc.) from a
date?

Thanks

Regards

Reply to this Message

Stewart Allen - 20 Jun 2004 11:47 GMT

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

> Hi
>
[quoted text clipped - 4 lines]
>
> Regards

Reply to this Message

Don Leverton - 20 Jun 2004 14:19 GMT

Hi John,

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

HTH,
Don

> Hi
>
[quoted text clipped - 4 lines]
>
> Regards

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.