Birthday Calc field
I have a date of birth field that displays "02/06/1955." How can I create a calc field to display the month and day only? I'm going to use this in a portal to display upcoming birthdays. Thanks
Why not use your date of birth field with a custom date format that only displays the day and month? This can be set up on the Inspector's data tab.
This worked perfectly! Never knew that option existed. Any tips on how to filter this by month? I tried MyTable::DOB = Month (Get (CurrentDate)) but nothing is displaying. Thanks
"filter" in what context? performing a find? listing records in a portal? or in a value list?
In a portal.
Month ( MyTable::DOB ) = Month (Get (CurrentDate))
I decided to go one step further and add a global field above the portal, so the user can select the month they desire, and see all birthdays in the portal for that month. I need to make this global a date field to match the DOB field in the portal. Is there any way that I can get the global field to display "January, February, March ...." using this method? Or should I be looking to make a calc field for the month found in the DOB field, and use a text Global? Thanks
Simplest would be:
YourTable::GlobalMonthName = MonthName ( MyTable::DOB )
Retrieving data ...