Microsoft Office Forums

Thread Tools Display Modes

sysdate query in ms access

Posts: n/a
      12-03-2004, 08:29 AM
how could i return the system date by the use of query in ms access
Reply With Quote
Nikos Yannacopoulos
Posts: n/a
      12-03-2004, 08:52 AM
Use built-in function Date(). It will return the system date and can be used
anywhere in Access, not just queries.


"sukhwinder" <(E-Mail Removed)> wrote in message
news:9A2D06CE-1A0B-4D59-9C79-(E-Mail Removed)...
> how could i return the system date by the use of query in ms access

Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting SysDate from back end PC instead of front end PC? (PeteCresswell) Access General 11 08-18-2007 11:22 PM
Can I automatically assign a Project name with the sysdate and log BioPM Project General 1 08-18-2006 09:58 PM
using sysdate in "if" function Avinash Excel Worksheets 3 05-06-2006 08:02 AM
Sysdate Equivalent Mark Watkins Access Queries 3 10-28-2003 09:50 PM
If new record, then populate field with sysdate andy Access General 3 08-20-2003 03:28 PM

All times are GMT. The time now is 02:41 PM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.

Welcome to the Microsoft Office Forums

Latest Threads
Mail Merging Content With High Quality
oleander (04-17-2014, 11:59 PM)

Aargh. What is this?
PeteJ (04-17-2014, 12:10 PM)

Word 2013 Insert Symbol (Not Responding)
tpthrshr (04-17-2014, 02:49 AM)

Can't save a large Word document
Josh (04-17-2014, 01:03 AM)

Remote help?
newman200 (04-13-2014, 12:54 PM)