Jump to content
Sign in to follow this  
Ponderosa

Automating Date Lookups

Recommended Posts

Posted (edited)

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 by Ponderosa

Share this post


Link to post
Share on other sites
Posted (edited)

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 by Lee Smith
change the explanation

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

ReleaseDate an auto entered date field:

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

  • Thanks 1

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.