Skip to main content
Question

Convert Numeric Fields to Birth Date

  • February 6, 2024
  • 0 replies
  • 95 views

Forum|alt.badge.img+6

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-YYYY). We are doing it this way because users in other countries need to populate the info and we have to make sure they don't enter a date as DD-MM-YYYY. By having the 3 different fields, that allows us to control the output.

I have tried using both the original field values and the numeric field values but can't get the right output. What is the best way to convert multiple choice fields to a date field? Thank you!



------------------------------
Amy Gosz
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • Registered
  • February 6, 2024

ToDate( [Month] & "-" & [Day] & "-" & [Year]) should do it (swapping out your actual field names of course)



------------------------------
Chayce Duncan
------------------------------

MarkShnierYou
Forum|alt.badge.img+24

Np, 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
------------------------------