Hi,
Below is a access query which is using dateserial function.
can you please convert the below query into equivalent TSQL using function and calling that function into the stored procedure.

"select DateSerial([cy],IIf([mois_activity_plan]="Janvier",1,Null,1) from Table"

datatype for "cy" and "mois_activity_plan" are "text" in the table.
Dateserial function has the formatateserial(year,month,day)

please help.

Many thanks,

rakesh