agaperrk Posted February 23, 2012 Share Posted February 23, 2012 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. Link to comment Share on other sites More sharing options...
Ocean West Posted February 23, 2012 Share Posted February 23, 2012 in a date field find */*/2011 Link to comment Share on other sites More sharing options...
agaperrk Posted February 29, 2012 Author Share Posted February 29, 2012 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 Link to comment Share on other sites More sharing options...
comment Posted February 29, 2012 Share Posted February 29, 2012 Try: Enter Find Mode [] Set Field [ YourTable::Datefield ; Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) ) - 1 ) & "…" & Date ( 1 ; 0 ; Year ( Get ( CurrentDate ) ) ) ] Perform Find [] Link to comment Share on other sites More sharing options...
LaRetta Posted February 29, 2012 Share Posted February 29, 2012 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! Link to comment Share on other sites More sharing options...
Lee Smith Posted February 29, 2012 Share Posted February 29, 2012 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)". Link to comment Share on other sites More sharing options...
agaperrk Posted February 29, 2012 Author Share Posted February 29, 2012 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. Link to comment Share on other sites More sharing options...
comment Posted February 29, 2012 Share Posted February 29, 2012 Are you asking, answering? Link to comment Share on other sites More sharing options...
agaperrk Posted February 29, 2012 Author Share Posted February 29, 2012 I was just showing that i had the current year done but I am having issues with the Previous Year. Link to comment Share on other sites More sharing options...
comment Posted February 29, 2012 Share Posted February 29, 2012 And my post #4 above ... ? Link to comment Share on other sites More sharing options...
agaperrk Posted March 1, 2012 Author Share Posted March 1, 2012 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. Link to comment Share on other sites More sharing options...
comment Posted March 1, 2012 Share Posted March 1, 2012 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. Link to comment Share on other sites More sharing options...
LaRetta Posted March 1, 2012 Share Posted March 1, 2012 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: Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4430 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now