falkaholic Posted February 27, 2002 Share Posted February 27, 2002 Ok. this is a hard one (I think). I have a self-related portal for currency of transaction in invoicing DB (US$ or CA$). I have 'CAD' and 'USD' in globals and used as the primary key to itself, and 2 relations for them. This works fine but I have to be able to show transactions from a date range. I can't think of a way to make a calculation field do this, since it has to be a range of dates. ideas anyone? Link to comment Share on other sites More sharing options...
BobWeaver Posted February 28, 2002 Share Posted February 28, 2002 It's not impossible, but it can be tricky. If the date range is always constant, like one week for example, you can set up a key field like this: StartDate & " Link to comment Share on other sites More sharing options...
falkaholic Posted February 28, 2002 Author Share Posted February 28, 2002 its varies. thats the problem. but in the mean time i found this amazing artical: http://www.onegasoft.com/articles/smartranges/index.shtml I'm having problems getting it working cuz my situation is a little bit different. I think i might be close. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8091 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