Skip to main content
Question

Convert text fields to a Date Field

  • November 7, 2018
  • 0 replies
  • 77 views
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.
    This topic has been closed for replies.

    np
    Date([Publication Year],[Publication Month],1)

    That assumes that those two fields for year and month are numeric fields.
    • MichaelHalbrein
    • Author
    • Quickbase Alumni
    • November 7, 2018
    perfect.  thank you!
    Terms & ConditionsAccessibility statement