Lose Dates When Converting File to v8

[phljoe]

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

[Lee Smith]

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

[Raybaudi]

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

[Lee Smith]

Good catch Daniele.

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

Lee

[phljoe]

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.