Text to date conversion problems

[SGT]

I'm am trying to "construct" a date by concatenating 3 text fields together.  I need this to be a date so that I can use date intelligence functions with it.  The formaula in dax is: PeriodDate = value(dim_Time[FiscalYear]) & "/" & value(dim_Time[Period]) & "/" & value(dim_Time[Week]).  The new column looks like a date, but it does not function as one.  When I try something like this: DATEDIFF(TODAY(),dim_Time[PeriodDate],DAY)  I get an error that says "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.. The exception was raised by the IDataReader interface."  

Thanks in advance.

[Greg_Deckler · Accepted solution]

Can you just use the DATE function?

https://msdn.microsoft.com/en-us/library/ee634927.aspx

[SGT]

Worked like a charm (once I removed invalid month values).  Thanks so much!