Date function for period and fiscal year

[#1]

hi i have two fields

Fiscal Year = 2013

Period = 1

if i concatenate these two and then try to create a date field using the Date function date(Date, 'YYYY-MM-DD') i recieve the following

1955-02-21

i wish to see 2013-01-01.

is there something i have missed with the date function?

Best,

Brad

[Clever_Anjos · Accepted solution]

date(makedate(2013,1),'YYYY-MM-DD')