Microsoft Office Forums


Reply
Thread Tools Display Modes

sysdate query in ms access

 
 
sukhwinder
Guest
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
Guest
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.

HTH,
Nikos

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



 
Reply With Quote
 
 
 
Reply

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 01:33 AM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.


Welcome!
Welcome to the Microsoft Office Forums
 


Latest Threads
New user looking for shapes/templates
SargeUSMC (04-21-2014, 04:23 PM)

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)