Get date of previous day

How to get short date of previous day ?

dim d as date msgbox(d.ShortDate) return 10/19/15

But I would like 10/18/15.

Thanks for your Help. :slight_smile:

Pourquoi faire compliquer quand on peut faire simple. (J鈥檃i vraiment l鈥檈sprit tordu).

dim d as new date MsgBox(d.shortdate)

retourne 18/10/2015.

MERCI Jean-Paul

don鈥檛 forget the keyword 鈥淣EW鈥 or you will have an unitialized date object