Lee J Posted January 19, 2001 Share Posted January 19, 2001 Can anyone please help. I would like to create a field which contains the date range to search on. I ask my users to enter the date range in two different fields. and then i need to combine these and get FM to search on the calculated result. I'm looking into the TextToDate() routine but to no joy. i.e DateStart (Date)= 1/1/01 DateEnd (Date)= 31/1/01 DateResult (Calc)= 1/1/01...31/1/01 Thanks in advance Link to comment Share on other sites More sharing options...
Chuck Posted January 19, 2001 Share Posted January 19, 2001 The way I handle this is to store the two dates in a two global date fields, then enter find mode (without restoring the find requests) and use Insert Calculated Result [ Search_Field, gStart_Date & "..." & gEnd_Date ] Perform Find Chuck Link to comment Share on other sites More sharing options...
Lee J Posted January 19, 2001 Author Share Posted January 19, 2001 Much appreciated, it works a treat the flip side is that they can't accidently modify and date fields to if the layout option changes. Thanks. p.s your second name isn't "Weger" by any chance? Chuck Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8519 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