# zeddicus

Members

11

0

1. ## Calculate the days between current date & another

Hi all, I worked my way around and got it working. Thanks for all your help!! For some reason, although the data field (Calculation) was storing the result as a number, the Perform Find function was treating as text. Once again, thanks for all the assistance and more importantly the patience!
2. ## Calculate the days between current date & another

OK, sorry I guess I just didn't understand what you were saying. I'll work it ou ton my own somehow after doing a bit more research. Thanks anyway.
3. ## Calculate the days between current date & another

Look, I'm sorry if you are getting annoyed but I don't see where I've left the "Enter Find Mode []". I have tried everything that has been suggested.
4. ## Calculate the days between current date & another

I'm sorry I don't understand what you mean by "You left the Enter Find Mode []
5. ## Calculate the days between current date & another

AAAAAGGGGGHHHHH!! Even with that change it still doesn't work. Here is the full script. Allow User ABort [Off] Show All Records (Just to ensure that all records are avilable to the find) Go to Layout ["Expiry Summary"] (Name and contract expiry date) Enter Find Mode [] Perform Find [specified Find request: Find Records; Criteria: Table::Expire: < 28] [Restore] Sort Records [specified Sort Order: Table::Name; ascending [Restore; No dialog] Adjust Window [Maximize] Pause/Resume Script [indefinitely] Enter Browse Mode
6. ## Calculate the days between current date & another

Play nicely you too!! Hee hee Feel free to assume I know nothing!! OK. This is where I've got to. I'm trying a different tack. I've managed to establish a field (called Expire)that has a calculated value that is the difference between the two dates. eg 5/7/2005 and 23/7/2005 has a value of 18. The values in this field with test data are 126, -5, 12, 141 & 14 But! when I do the following Enter Find Mode [] Perform Find [specified Find request: Find Records; Criteria: Table::Expire: "< 28"] [Restore] It returns no records even though there are 3 that fit. Any hints on this?
7. ## Calculate the days between current date & another

When I enter Set Field [ WAAC Volunteer Database::Volunteer Contract Expiry Date ; ">" & Get(CurrentDate) + 28 ] I keep getting an error message saying "An operator is expected here" for everything from the semi colon after "Volunteer Contract Expiry Date". Regards
8. ## Calculate the days between current date & another

Hi LaRetta, You're having trouble following the logic!! Hee hee I am starting to think I should throw it out and get an exercise book!! I'll try making your changes and let you know. Thanks for taking the time.
9. ## Calculate the days between current date & another

Thanks everybody so far, it is starting to make sense now, but I still can't get it to work. I've set up record where "Volunteer contract expiry date" is before the 28 day period, in the 28 day period and after the 28 day period in question. The Datafile is called WAAC Volunteer Database Some of the relevant fields are - Last Name (Text) - First Name (Text) - Volunteer Contract Expiry Date (Date) - Expire (Number) Here are two scripts I've tried. *********************** Allow User Abort [Off] Set Error Capture [On] Go to Layout ["VOLUNTEER CONTRACT EXPIRY"] [Prints Last Name, First Name and Volunteer contract expiry date] Print Setup [ Orientation: Portrait; Paper Size: 8.26" x 11.69" ] [Restore] Enter Find Mode [ ] [Pause] Set Field [WAAC Volunteer Database::Volunteer Contract Expiry Date &#8804; (Get(CurrentDate) + 28) Perform Find [ ] Sort Records [specified Sort Order: WAAC Volunteer Database::Last Name; ascending WAAC Volunteer Database::First Name; ascending] [Restore; No dialog] Adjust Window [Maximize] Pause/Resume Script [indefinitely] Enter Browse Mode [Pause] Go to Layout["REPORTS"] ******************* and (supposed to convert to a number) ******************* Allow User Abort [Off] Set Error Capture [On] Go to Layout ["VOLUNTEER CONTRACT EXPIRY"] [Prints Last Name, First Name and Volunteer contract expiry date] Print Setup [ Orientation: Portrait; Paper Size: 8.26" x 11.69" ] [Restore] Enter Find Mode [ ] [Pause] Set Field [DayOfYear(WAAC Volunteer Database::Volunteer Contract Expiry Date) &#8804; (DayOfYear(Get(CurrentDate) + 28)) Perform Find [ ] Sort Records [specified Sort Order: WAAC Volunteer Database::Last Name; ascending WAAC Volunteer Database::First Name; ascending] [Restore; No dialog] Adjust Window [Maximize] Pause/Resume Script [indefinitely] Enter Browse Mode [Pause] Go to Layout["REPORTS"] ************************ What am I doing wrong? Thanks in anticipation!!! RK
10. ## Calculate the days between current date & another

Thanks for that but when I try to put the line Insert Calculated Result [ Untitled::expiDate; Get ( CurrentDate ) - 28 ] in to Scriptmaker I keep getting the text "; Get ( CurrentDate ) - 28 ]" highlighted and an error message saying "An operator is expected here."
11. ## Calculate the days between current date & another

I am new to scripting and I am trying to create a script that will return all records that have an expiry date less than 28 days away from the current date. I have tried half a dozen different ways with no success. It is the last script I need to creat for this current project. Can anyone please help before I throw my computer off a very high cliff.
×
×
• Create New...