Search the Community
Showing results for tags 'date'.
-
Hi FM people! I have one problem which is probably simple to solve but so far solution eluded me. I have a dropdown text field which offers a list of years (Table::Years). This is global field. I have very simple find script: Enter Find Mode [Pause: Off] Set Field [Table::Order...
-
I have searched the web for a Custom Function that solves this to no avail… There are many CF’s that “almost” do what I need but nothing as explained below. OBJECTIVE: Calculate a DATE x days AFTER a given date skipping weekends AND bank holidays. GIVEN: StartDate Nu... -
Hi, 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. Thanks, Paul
-
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 DateCalc.fmp12
-
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 ( M...
-
So, here's something I've lived with forever and I'm finally asking for help! Can you set a default date format? I'd like all my date fields to display as mm/dd/yy. However, I find that I must use the Inspector's Date Format to do so and I cannot see how to make that the default format. An...
-
Hi 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.
-
Folks I'm having a bit of headache with a search script. I want to search a date range from today to 90 days in the future. Currently I've made a script with a step saying: Insert Calculated Result [Select; "date field"; ( Get (CurrentDate) & "..." (Get (CurrentDate) + 90)] Being in... -
I recently imported records from an excel sheet into my filemaker solution. I just noticed that the dates in the excel sheet were entered in this format 1996-04-19 and as a result, all my date calculations are not working. For example, the Age and other functions. Manually changing the date to... -
Can anyone explain how FM treats a summary field if weighted by date? For example, say I have one transaction each month over 5 years. I want an average of these that would be a total each month's transaction values divided by 60. What if this were weighted by date?
-
Hi, Can anyone help? I'm using the script below and after adding to the DB it has altered the date format ( payment date) to US MM/DD/ YY style. Case ( IsEmpty ( PaymentMethod ) ; " Invoice Status" ; TextStyleAdd ( PaymentStatus & " " & payment date ; Bold) & ¶ & TextSize ( Paymen...
-
I have a customer database and with a customer table and a service call table. I am looking to create a report that would summarize total payment received in each month and a total for any given year with a grand total of every year. Not sure how to set up the layout part for the Year and Month so...
-
Hello As you will notice, I'm working like mad on starting point to get it customized to taste! I found this issue with DATE FORMATTING. I use "the rest of the planet" date format DD/MM/YYYY which is my system date format. Everything goes OK until now. I tried to change a payment period fro...
-
Hello, Hope someone can help with this one! I have a simple Prospects list, where I have an 'Expected Date' field (Date), which is set to just show month and year. How would I setup the conditional formatting to set the colour of this 'Expected Date' field according to the 'current month', 'next...
-
Hi, I have a portal with five fields - 3 text, 1 date, 1 number; the first row displays all five fields correctly and the following rows display only the text fields. Any ideas as to what I'm missing here?
-
A date field in my database is formatted as 2015-03-01 in the layout mode. When exporting to a csv the date is written 01/03/2015. Why and how do I change it?
-
There is probably a simple solution to this problem that I'm not seeing but I've read through my entire 900 page FileMaker Pro Missing Manual and I can't find the appropriate answer; I'm using FMP 13 Advanced and I have some basic experience writing scripts, etc. Here's The Goal: To start each... -
I have a few situations where I need to be something specific having to do with dates. For the sake of this example, let's say we're dealing with pay periods. Â payperiods table will have 1 record for each pay period. It will have a pay period number, a date the pay period starts and a date the...
-
A function to finds all the dates for a week day within an given date range. For example: We need to find what are the dates for the Thursdays in the date range starting from 1/1/2013 to 1/31/2013. In this case: The function would be defined as FindDay ("1/1/2014";"1/31/2014";5) Here the... -
I'm using FP 11 with MacBook pro System 10.6.8. I have a database of about 3000 records with various fields, one being "date created". I want to add a field to my layout for "date updated" so that whenever I make a change to a record, this field shows the date of that last change. This...
-
Looking for some advice on my due date calculation. My calculation is working, but wondering if it is as sound as it could be. due_date = [ invoice_date + terms ] Should this be written better?
-
hello, i hope someone can help me with this. I am creating a field that is a concatenation calculation, the purpose of which is to combine multiple pieces of information into a unique number that will be used on our contracts. One of the pieces of information to be included is the date of the co... -
We are using FMP 12 Advanced, we have a layout in which we print an award certificate. We would like to be able to create a calculation field that draws from an existing date field (call the existing date field: "Date Awarded") the contents of that field would be a date value ex: 2/2/2012 this date... -
Hi folks I'm having a problem using the MAX calculation. I have one table linked to another via URN and I just want to select the max value in the linked table by the max (or latest) date. So, if on 18/2/11 I have a record with an N (in the approved field) but on the 23/2/11 I then have a Y in the...
-
I am trying to create an autogenerated Id number for an invoice but this number must be prefixed by the year for example 2012/1 however at the start of each new year these number need to go back to 1 so for example the first invoice next year will be numbered 2013/1. can anyone suggest the best way...
