Automating Date Lookups

[Ponderosa]

So there's probably something simple, but do you guys know of a way to automate dates from one record to the next? Each record date needs to be seven days after the previous one, and I'd like for my client not to have to enter it manually. I tried doing

Let ( Today = ( ReleaseDate ) ;

Date ( Month ( Today ) ; Day ( Today ) + 7 ; Year ( Today ) )
) 

 

and some others, but none appear to automatically fill in. Help!

Edited January 8, 2018 by Ponderosa

[Lee Smith]

Hi Ponderosa and welcome to the FM Forums,

I  moved your question from the Discussion topic for Version 15 to the Calculations topic  because, this topic fits your question.

Your calculation could be simply,  ReleaseDate + 7

A calculation field that is dependent upon another field, should fill in when the other field has data that fits the result. In other words, Field B is dependent on data being in Field A. Also, check your calculation fields to ensure it has a result of "date."  In addition, if you are seeing a "?" the field, be sure that it has enough room to show. You can test this by clicking into the field.

HTH

Lee

Edited January 8, 2018 by Lee Smith
change the explanation

[Ponderosa]

Thanks for moving my question! I still haven't quite figured out how to 'label' my questions properly.

 

My problem is that I want the "+7" stuff to calculate from the same field, but in a previous record, so that each record jumps ahead by seven days. I don't know how (or if it's even possible) to give it a start date in that same field in the first record, and then start calculating accordingly. Is this making sense?

I really appreciate the help.

[Lee Smith]

Why not post a copy of your file so we can see your schema?

This article by Ocean West, the owner of the Forum, explains how to do this without compromising your confidential information.

Anatomy of a Good Topic. Please let me know if you have a problem using Private Message.

TIA

Lee

[Fran_g]

ReleaseDate an auto entered date field:

GetNthRecord ( ReleaseDate; Get ( RecordNumber ) - 1 ) + 7

[Ponderosa]

Haha! SUCCESS! Thank you, both. Fran_g, that worked perfectly once I turned the "Do not replace existing value of field (if any)" on. Every time I created a record now, the field automatically populates with a day 7 days hence. Woot!