Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft training access course - date time

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Date$ Time$

microsoft training access course - Date$ Time$

ResolvedVersion Standard

Clare has attended:
Access Introduction course

Date$ Time$

Can you please tell me what the dollar sign represents in the Built in Functions under Functions under the Build option.
There seems to time, time$, date and date$ - what is the difference between them?

RE: Date$ Time$

Returns the current time. Time$()gives it as a string.

Gives today's date. Date$() gives it as a string.

A "string" is a series of bits that represents some piece of text in human language. What you're reading now is text. Strings are how this text is represented inside a computer.

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes


Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.