Hi Experts,
Could you help to convert the year =2018 of string type to previous year that is 2017
then this PY = 2017 tobe used in below datetime formula as follows:
=ToDate("1"+"/"+"1"+"/"+[PY];"M/d/yyyy") // formula throws #Error
Appreaciate your help in the formula
Thanks,
Dinya