EddyB Posted July 5, 2003 Share Posted July 5, 2003 Hi all, I have seen quite a few posts on the board asking about date calculations so... This won't be a lot of use for those of you who are quite experienced, but for any newbies who need an example of date calculations then I hope this helps. Credit goes to Ugo for the calculation to work out the amount of months! Please feel free to update or add to this if you know of any other date examples which may be useful to newbies but please do not remove anyone elses work on the example without checking with them first. BTW is also contains the example of hiding fields in a portal which I found on this forum - sorry can't remember who I got this off though. Regards Ed. DateCalcExamples.zip Link to comment Share on other sites More sharing options...
Lee Smith Posted July 5, 2003 Share Posted July 5, 2003 Hey Ed, I loved the way everything *Popped* when you fill in the DOB Very clever. Lee Link to comment Share on other sites More sharing options...
EddyB Posted July 5, 2003 Author Share Posted July 5, 2003 Thanks Lee! It is quite clever but as I say I cannot take credit for that one - *******! Just wish I could find who gave me that example! Link to comment Share on other sites More sharing options...
EddyB Posted July 6, 2003 Author Share Posted July 6, 2003 Hi all, I've remembered where I got this little "hide trick" from. It was from John Mark Osborne's site Database Pros The file you're looking for is called MoreVis.FP5. It details 4 different tricks using portals to hide information. The last trick is VERY useful. It shows users a list of checkbox items but it is greyed out. You cannot select an item until you have entered a date into a field. I have found it very useful in some of my solutions, I hope you find it as useful as I have Ed. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted July 6, 2003 Share Posted July 6, 2003 Nice Job, Eddy.... Thanks for the credits, even if the thread where you catched it had some other interresting alternatives. Why not incorporate an Astro to it ? Choose(Month(date1),"", Case(Day(date1) < 21,"capricorne","verseau"), Case(Day(date1) < 20,"verseau","poissons"), Case(Day(date1) < 21,"poissons","b Link to comment Share on other sites More sharing options...
EddyB Posted July 7, 2003 Author Share Posted July 7, 2003 Thanks Ugo. I have just amended the attachment so please download again. I have added/changed the following: **No more ugly black screen when inside the portal **Added "D.O.B in words" - possibly the longest calc I have ever done! - if anyone knows of a way to shorten this, please let me know! **Added Astrology sign **Added Chinese Zodiac **Added Clear button - hidden inside seperate portal Regards Ed. Link to comment Share on other sites More sharing options...
Lee Smith Posted July 7, 2003 Share Posted July 7, 2003 Someboby has too much time on their hands very nice Link to comment Share on other sites More sharing options...
EddyB Posted July 7, 2003 Author Share Posted July 7, 2003 Just taking a break from my current solution - it's getting a bit tedious! Needed to work on something else for a while! Ed. Link to comment Share on other sites More sharing options...
Recommended Posts