Current date in Header

[Jack]

Here's any easy one, but I just can't get it to work.

I want the current date to be displayed (and printed) in the Header.

I've created a date field and have tried using "Today" plus most of the other "date" functions, but nothing shows up on the screen.

Thanks.

~ jack

[EddyB]

Hi Jack

In the layout just type the following text:

//

This displays the current date

If you did want to use a field though you are best using the Status(CurrentDate) Function.

Ed.

[Jack]

Hi Ed

Thanks for the quick reply and of course I'll use the

in my header.

I am just wondering why I can't get Status(CurrentDate) to display anything.

In any event you solved my immediate problem.

Now you might as well take the rest of the day off...

Thanks.

~ jack

[EddyB]

Hi Jack,

Firstly make sure you use // and not

Now, your calculation. Make sure that the calculation field is set to be date format.

Ed.

[EddyB]

Hi Jack,

Just to explain why I said to use Status(CurrentDate) instead of Today if you were to use a field to do this.

With the Today function, the database has to be closed and reopened before the date is updated.

For example if you had a database open now it would have 17/06/03 as the Today date, but tomorrow, if the database had not been restarted, the date will remain as 17/06/03.

This is not the case with the CurrentDate function

Secondly when the database is restarted to update the Today function, this field in every record has to be recalculated. So if you have hundreds of thousands of records it will take a good while to reopen the db as it will need to recalculate that many times.

Again, this is not the case with Status(CurrentDate)

Ed.

[Jack]

Thanks for the info.

I now recall reading somewhere (probably on this forum) that TODAY only updates when opening/closing database. Hopefully now I'll remember it.

Appreciate the help !

~ jack

[Vaughan]

Make sure the Status(CurrentDate) calculation is set to unstored, otherwise it won't change either!

[Jack]

Oh, so thats the trick !

~ jack