Fountain of Youth Found

[mborgens]

I have a solution that is served on a PC that has an age feature. Everyone is no longer aging. Ponce might appreciate dilemma; I think FM has aged me at an increased rate. I also use a pop up field with today's date that uses the "Today" calculation. Each morning it should calculate today's date; this too has discontinued. Does anyone know how to help me get out of Florida; my birth date is coming up and I'd like to be able to celebrate it.

Thanks, donny

[Anatoli]

Don't use Today or restart the server every day at 00:00.

There is function Status (CurrentDate) for this.

[CobaltSky]

Judging by the photo, I'd say Anatoli knows all about the fountain of youth... I'd swear he looked at least a tad older than that in the last pic I saw of him?!!

If that's the effect it has, I definitely going to experiment with this technique of not re-starting the server!

[mborgens]

For a value list to pop up with today's date in it, I don't think you can use Status (CurrentDate) because it can't be stored. I thought if you select stored it won't continue to update, and if it isn't stored, it can't be used in a value list. Can it be done without the Today feature?

I'm not sure the server issue is related to the Today calc. It used to work and then just stopped. Age is not based on Today, and ages stopped aging.

I've seen the fountain and it sucks.

marie

[CobaltSky]

The question is, can you force it to recalulate by shutting down and reopening the file.

If not, also check whether fields set to acquire a date (eg via the 'Auto enter creation date' feature) are working. If the answer is no to both of these then check for a system date setting problem or for a corrupt preferences file - or last but not least, a corrupt database file.

If these are working, then FMP is acquiring dates and applying them, and you will be able to work backwards from there to identify the source of the problem.