Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Linking Tables - dates

Hi,    I have a master Date table, and I'm trying to link it to a number of other tables, all with Year and Month. The Year and Month columns in my other tables are stored as Text, which I think mi...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    In the Other Table, generate a genuine date from the Month and Year by using this formula

     

    =1*("1/"&Table2[Month]&"/"&Table2[Year])

     

    Format this new column as Date and give it a meaningful heading.  Now create a relatioship from the Date column (that you just created with the formula above) of the Other Table to the Date column of your caalendar table.

     

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Ashish_Mathur

 

I've tried this same formula in a different table, and now I'm getting the below error message.

 

Any ideas why?

 

Thanks again for your help

 

Sonia

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    The year and/or month column has atleast one blank cell.  Try this

     

    =IFERROR(your formula,DATE(1900,1,1))

     

    Does this work?