Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Find a previous Year

finds previous year.

  • Please log in to reply
12 replies to this topic

#1 agaperrk  enthusiast

agaperrk
  • Members
  • 85 posts
  • FM Application:7
  • Time Online: 8h 57m 3s

Posted 22 February 2012 - 04:21 PM

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.
  • 0
___________________________
Randy Koonce
email:koonce@randykoonce.com
www.randykoonce.com

#2 Ocean West  I have an idea!

Ocean West
  • Administrators
  • 2,779 posts
  • LocationSan Diego
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 11, 12, 13
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 47d 2h 30m 14s

Posted 22 February 2012 - 04:43 PM

in a date field find

*/*/2011

  • 0
Stephen Dolenski
FM Forums.com Founder, Administrator

#3 agaperrk  enthusiast

agaperrk
  • Members
  • 85 posts
  • FM Application:7
  • Time Online: 8h 57m 3s

Posted 29 February 2012 - 08:26 AM

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
  • 0
___________________________
Randy Koonce
email:koonce@randykoonce.com
www.randykoonce.com

#4 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 39s

Posted 29 February 2012 - 09:36 AM

Try:

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

#5 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,810 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 220d 7h 19m 59s

Posted 29 February 2012 - 10:01 AM

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!
  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.

#6 Lee Smith  I like the v13 layout tools

Lee Smith
  • Staff
  • 10,152 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 229d 7h 30m 51s

Posted 29 February 2012 - 11:01 AM

Automatic message


This topic has been moved from "FileMaker Product FamilyFileMaker LegacyFileMaker Pro 7" to "Database Schema & Business LogicCalculation Engine (Define Fields)".
  • 0

#7 agaperrk  enthusiast

agaperrk
  • Members
  • 85 posts
  • FM Application:7
  • Time Online: 8h 57m 3s

Posted 29 February 2012 - 02:10 PM

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.
  • 0
___________________________
Randy Koonce
email:koonce@randykoonce.com
www.randykoonce.com

#8 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 39s

Posted 29 February 2012 - 02:14 PM

Are you asking, answering?
  • 0

#9 agaperrk  enthusiast

agaperrk
  • Members
  • 85 posts
  • FM Application:7
  • Time Online: 8h 57m 3s

Posted 29 February 2012 - 02:51 PM

I was just showing that i had the current year done but I am having issues with the Previous Year.
  • 0
___________________________
Randy Koonce
email:koonce@randykoonce.com
www.randykoonce.com

#10 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 39s

Posted 29 February 2012 - 03:14 PM

And my post #4 above ... ?
  • 0

#11 agaperrk  enthusiast

agaperrk
  • Members
  • 85 posts
  • FM Application:7
  • Time Online: 8h 57m 3s

Posted 29 February 2012 - 04:24 PM

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.
  • 0
___________________________
Randy Koonce
email:koonce@randykoonce.com
www.randykoonce.com

#12 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 39s

Posted 29 February 2012 - 04:44 PM

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.
  • 0

#13 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,810 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 220d 7h 19m 59s

Posted 29 February 2012 - 05:11 PM

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. :laugh2:
  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.




FMForum Advertisers