Changing a variable into a date

[kwirth]

I'm trying to figure out how to incorporate a year variable I have into a casting into a date.

I want to be able to type in the month and day, but insert the year that is in the data.

Ideally, I want to do something like this, but it doesn't work as is. Any thoughts?

cast('[YEAR]-01-09',date)

[Lynn]

I'm trying to figure out how to incorporate a year variable I have into a casting into a date.

I want to be able to type in the month and day, but insert the year that is in the data.

Ideally, I want to do something like this, but it doesn't work as is. Any thoughts?

cast('[YEAR]-01-09',date)

Code Select Expand


cast( [YEAR] || '-01-09' , date )


Code Select Expand


cast( [YEAR] || '-' || ?SelectMonth? || '-' || ?SelectDay? , date )


Something along these lines might help although zero padding in front of the entered values might be something you have to deal with.

[AnalyticsWithJay]

One other solution is to try creating this expression using functions from your database vendor, because cast() is a locally-processed function, and could possibly degrade performance.