microsoft training access course - Date$ Time$

Resolved · Low Priority · Version Standard

Wed 7 Feb 2007, 14:35 Delegate Clare said...

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?

Wed 7 Feb 2007, 16:39 Trainer Garry said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips