Skip to Content
0
Jun 11, 2018 at 04:55 PM

FormatError in Date time

51 Views

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