Forum Discussion
JimNewton
6 years agoQrew Trainee
Thanks everyone for the comments and help. Part of the struggle is that we want to be able to show the Month/Date and the current year... I was able to accomplish this in a horrifically inefficient way, but here goes my solution:
Created a "DOB" [Date Field] (Technically, Optional)
Created a "Month of DOB" [Text Field]
Created a "Date of DOB" [Text Field]
Created a "Today" [Date/Time Formula Field - Now()]
Created a "Year" [Text Formula Field - Year(ToDate([Today]))]
Created a "Current Year DOB" [Text Formula Field - [Month of DOB]&"-"&[Date of DOB]&"-"&[Year]]
Created a "Current Year DOB01" [Date Formula Field - ToDate([Current Year DOB])]
For Next Year:
Create a "Next Year" [Numeric Formula Field - ToNumber([Year])+1]
Create a "Next Year DOB" [Text Formula Field - [Month of DOB]&"-"&[Date of DOB]&"-"&[Next Year]]
Create a "Next Year DOB01" [Date Formula Field - ToDate([Next Year DOB])]
I'm going to replicate this for the anniversary need.
I appreciate everyone's help!
Created a "DOB" [Date Field] (Technically, Optional)
Created a "Month of DOB" [Text Field]
Created a "Date of DOB" [Text Field]
Created a "Today" [Date/Time Formula Field - Now()]
Created a "Year" [Text Formula Field - Year(ToDate([Today]))]
Created a "Current Year DOB" [Text Formula Field - [Month of DOB]&"-"&[Date of DOB]&"-"&[Year]]
Created a "Current Year DOB01" [Date Formula Field - ToDate([Current Year DOB])]
For Next Year:
Create a "Next Year" [Numeric Formula Field - ToNumber([Year])+1]
Create a "Next Year DOB" [Text Formula Field - [Month of DOB]&"-"&[Date of DOB]&"-"&[Next Year]]
Create a "Next Year DOB01" [Date Formula Field - ToDate([Next Year DOB])]
I'm going to replicate this for the anniversary need.
I appreciate everyone's help!