Is there any simple way that i can get yesterday dates ?? for your information, the date format that i am using is MM/dd/yy.
Printable View
Is there any simple way that i can get yesterday dates ?? for your information, the date format that i am using is MM/dd/yy.
VB Code:
Public Function GetYesterday() GetYesterday=DateAdd("d",-1,now) End Function
VB Code:
MsgBox Format$(DateAdd("d", -1, Now), "MM/dd/yy")
MsgBox Date-1