![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have become accustomed to the conveniences of finding in FM8, and have apparently forgotten everything I knew about FM6. I have been asked to modify an existing solution in 6. Someone (Harry?) please refresh me on how I would script finding a range of dates using global date fields representing StartDate and EndDate and symbols. |
#3
| |||
| |||
|
|
Make sure the field you're searching on is on the current layout, and use the Insert Calculated Result step: datetotext(StartDate) & "..." & datetotext(EndDate) Matt Wills wrote: I have become accustomed to the conveniences of finding in FM8, and have apparently forgotten everything I knew about FM6. I have been asked to modify an existing solution in 6. Someone (Harry?) please refresh me on how I would script finding a range of dates using global date fields representing StartDate and EndDate and symbols. |
#4
| |||
| |||
|
|
I thought I had tried that, but did it again to make sure. For some reason, all that's being inserted is the ellipsis. Matt In article <12lmg6r3mi27df5 (AT) corp (DOT) supernews.com>, Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote: Make sure the field you're searching on is on the current layout, and use the Insert Calculated Result step: datetotext(StartDate) & "..." & datetotext(EndDate) Matt Wills wrote: I have become accustomed to the conveniences of finding in FM8, and have apparently forgotten everything I knew about FM6. I have been asked to modify an existing solution in 6. Someone (Harry?) please refresh me on how I would script finding a range of dates using global date fields representing StartDate and EndDate and symbols. |
#5
| |||
| |||
|
|
Are your StartDate and EndDate fields truly dates? Or could they be text fields? Matt Wills wrote: I thought I had tried that, but did it again to make sure. For some reason, all that's being inserted is the ellipsis. Matt In article <12lmg6r3mi27df5 (AT) corp (DOT) supernews.com>, Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote: Make sure the field you're searching on is on the current layout, and use the Insert Calculated Result step: datetotext(StartDate) & "..." & datetotext(EndDate) Matt Wills wrote: I have become accustomed to the conveniences of finding in FM8, and have apparently forgotten everything I knew about FM6. I have been asked to modify an existing solution in 6. Someone (Harry?) please refresh me on how I would script finding a range of dates using global date fields representing StartDate and EndDate and symbols. |
![]() |
| Thread Tools | |
| Display Modes | |
| |