Discussions

Expand all | Collapse all

Convert text fields to a Date Field

  • 1.  Convert text fields to a Date Field

    Posted 11-07-2018 15:09
    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.


  • 2.  RE: Convert text fields to a Date Field

    Posted 11-07-2018 15:37
    np
    Date([Publication Year],[Publication Month],1)

    That assumes that those two fields for year and month are numeric fields.


  • 3.  RE: Convert text fields to a Date Field

    Posted 11-07-2018 15:49
    perfect.  thank you!