Convert Numeric Fields to Birth Date
I have 3 multi-choice fields (Month, Day, Year) which contain numbers only and I have converted those fields to Numeric fields. I need to put the three fields together to get the birth date (MM-DD-YY...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNp, the function is Date ...
Date([YYYY], [MM], [DD])
The Date function expects numeric fields, and of course, just adjust those field names to match your own, but they need to be in that sequence year, then, the month, then the day.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Worked perfect! Just not intuitive that the year would be listed first but still get the output MM-DD-YYYY. Thank you Mark!
------------------------------
Amy Gosz
------------------------------