Jump to content

  •  

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,802 posts
  • LocationSan Diego
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Mac OS X Yosemite
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 11, 12, 13
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 49d 35m 52s

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,556 posts
  • Time Online: 344d 6h 25m 23s

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,989 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 243d 12h 9m 56s

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,290 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 244d 1h 22m 4s

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,556 posts
  • Time Online: 344d 6h 25m 23s

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,556 posts
  • Time Online: 344d 6h 25m 23s

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,556 posts
  • Time Online: 344d 6h 25m 23s

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,989 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 243d 12h 9m 56s

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