Need a help. Following is my code
lngRecdDate = Format(Date - 1, "DD-MMM-YYYY")
wbk.Sheets("Details").Cells(FoundRow, 17).Value = Format(lngRecdDate, "DD-MMM-YYYY")
It is working fine. However, some time the updated date is coming in DD-MMM-YY instead of DD-MMM-YYYY. Please guide me.
lngRecdDate = Format(Date - 1, "DD-MMM-YYYY")
wbk.Sheets("Details").Cells(FoundRow, 17).Value = Format(lngRecdDate, "DD-MMM-YYYY")
It is working fine. However, some time the updated date is coming in DD-MMM-YY instead of DD-MMM-YYYY. Please guide me.