Date Calculations Example

[EddyB]

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

[Lee Smith]

Hey Ed,

I loved the way everything *Popped* when you fill in the DOB

Very clever.

Lee

[EddyB]

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!

[EddyB]

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.

[Ugo DI LUCA]

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

[EddyB]

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.

[Lee Smith]

Someboby has too much time on their hands

very nice

[EddyB]

Just taking a break from my current solution - it's getting a bit tedious! Needed to work on something else for a while!

Ed.