Date Format | VB Functions | .Net Functions |
---|---|---|
First Date of last month | =DateAdd(“m”, -1, DateSerial(YEAR(NOW()), MONTH(NOW()), 1)) | =Today.AddDays(1- Today.Day).AddMonths(-1) |
Last date of last month | =DateAdd(“d”, -1, DateSerial(YEAR(NOW()), MONTH(NOW()), 1)) | =Today.AddDays(-1 * Today.Day) |
First date of current month | =DateSerial(YEAR(NOW()), MONTH(NOW()), 1) | =Today.AddDays(1 – Today.Day) |
Last date of current month | =DateAdd(“d”,-1,(DateAdd(“m”, 1, DateSerial(YEAR(NOW()), MONTH(NOW()), 1)))) | =Today.AddDays(-1 * Today.Day).AddMonths(1) |
Yesterday’s date | =DateAdd(“d”, -1, Today) | =Today.AddDays(-1) |
Tomorrow’s date | =DateAdd(“d”, 1, Today) | =Today.AddDays(1) |
First day of current year | =DateSerial(YEAR(NOW()), 1, 1) | =Today.AddDays(1- Today.DayOfYear) |
Last day of current year | =DateSerial(YEAR(NOW()), 12, 31) | =Today.AddDays(-1 * Today.DayOfYear).AddYears(1) |
Last day of current year | =DateSerial(YEAR(NOW()), 12, 31) | =Today.AddDays(-1 * Today.DayOfYear).AddYears(1 |