I’d like to show days since last race for a horse where the first race returns 0. I played around with ‘last’ and ‘GetNthRecord’ but something went wrong. I had some problems with races where the horse was scratched, but I can live with that.
Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) )
how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help.
Thanks for any help
I have been using the Scribe plugin to insert text into word-based tables as part of an annual report. I am using FM 16 on both Mac and Windows and have the very latest version of the Plugin.
I am able to insert the text into multiple tables throughout the document quite well. What is not happening is that the new data is not maintaining the formatting of the table. I would be fine with just holding the correct font and size.
Should the data insert into the word based tables retain the formatting and if so what determines that formatting because inserting the data into a fully preformatted table removes all the formatting and sets the data back to some kind of default font of Cambria 12 vs. the Helvetica 9 that is in the table?
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!
I am hoping someone can help me to do the below.
I have two fields 1 "Letter Sent" field(date) and 2 "Letter Received" field (date). I would like the "Letter Received" field to go red if no dated entered 7 days after the date entered in "Letter Sent" field.
I hope that makes sense.