Hello Everyone,

I'm using a small database that produces Friday dates. It worked fine in v6, but after converting to v8, it returns 0/00/000 in every instance. I can't figure out why. Anyone care to take a stab? It's attached. Thanks.

Issue_Dates_.zip

I'm seeing dates in the Fridays column, but a blank field in the Test friday number after the date of 5/5/2006. When I look at that field, it is only a Text field without any calculation attached. I'm really not sure what you see as broken here.

Lee

Hi

when you'll open with FMP8 you have to make a little modification to the script "Auto Fridays" adding a GetAsDate()function, so the final calc will be:

GetAsDate ( 7 * Int (Get ( CurrentDate ) / 7) + 5 + (Issue Dates::Record ID - 1) * 7 )

Anyway see attached .fp7 file

Issue_Dates_.zip

Good catch Daniele.

How embarising, I didn't even notice that it opened in v6. No wonder it looked okay.

Lee

Daniele,

Thank you very much for not only looking at this file, but also for making the correction. This file is related to another database which I will now be able to put online because of your help.

Joe

P.S. Lee thank you also for taking a look.