Convert text fields to a Date Field

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
I have two text fields:  [Publication Month] and [Publication Year].  I want to know convert this into a Formula Date Field called [Publication Date].  I will use the publication day as the 1st for every case.  This is the formula I tried but it didn't work.

ToDate([Publication Month Long] & "1, " & [Publication Year])

Can anyone help? It may just be simple formatting??

Thanks.
Photo of Michael Halbreiner

Michael Halbreiner

  • 230 Points 100 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
np
Date([Publication Year],[Publication Month],1)

That assumes that those two fields for year and month are numeric fields.
Photo of Michael Halbreiner

Michael Halbreiner

  • 230 Points 100 badge 2x thumb
perfect.  thank you!