12 replies to this topic

[agaperrk]

I would like to have a pull down or even a selct list to click on to have the system go out and find previous year. I already have a script for current year.  thanks in advance.

[Ocean West]

in a date field find

*/*/2011

[agaperrk]

Ocean West, on 22 February 2012 - 04:43 PM, said:

in a date field find

*/*/2011

the only problem i need it to do this every year without me putting the year in....


Year ( Get ( CurrentDate ) ) - 1  does not work on 7 it does however put the right year but the find does not work

[comment]

Try:

Enter Find Mode []
Set Field [ YourTable::Datefield ; Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) ) - 1 ) & "…" & Date (  1 ; 0 ; Year ( Get ( CurrentDate ) ) ) ]
Perform Find []

[LaRetta]

Michael, I am wondering why Year ( Get ( CurrentDate ) ) - 1 would not work.  It works in my tests ... just entering the year itself into a date field finds all records within that year.  And I know that YOU know it ... so why did it fail for agaperrk?  And why are you providing a range instead?

Never mind.  Version 7 ... I just opened it and tried and it doesn't work!  I did not know this functionality wasn't in 7!

[Lee Smith]

Automatic message


This topic has been moved from "FileMaker Product Family → FileMaker Legacy → FileMaker Pro 7" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".

[agaperrk]

GetAsText(Date( 1; 1; Year(Get(CurrentDate)) )) & "..." & GetAsText(Date( 12; 31; Year(Get(CurrentDate)) ))  This gets me the current year.. I guess i could use a minus 1 after the current date.

[comment]

Are you asking, answering?

[agaperrk]

I  was just showing that i had the current year done but I am having issues with the Previous Year.

[comment]

And my post #4 above ... ?

[agaperrk]

I was just pointing out that i have the current year and it does not work for me just to add a minus 1 unless there is a new way to do it........  I'm still looking for a solution for the previous year.

[comment]

OK, I'll ask again: have you seen my suggestion in post #4 of this thread? It is supposed to provide a solution for finding records from previous year.

[LaRetta]

agaperrik, why are you wrapping with GetAsText()?  You should be able to take Comment's calculation and just put it in the calculation dialog box exactly (copy it) as:

Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) ) - 1 ) & "…" & Date ( 1 ; 0 ; Year ( Get ( CurrentDate ) ) )

You are searching a date field, correct?  This doesn't need a drop-down list or anything else ... it will always change and always get the year prior to the current one in a regular Find script.