Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
format(dateadd("m",6,DateValue("2007-11" & "-" & 1 ) ) ,"yyyy-mm")
format(dateadd("m",6,DateValue("2007-11" & "-" & 1 ) ) ,"yyyy-mm")
SELECT ComputerID, WarrantyDateExpires, format(dateadd("m", 6, ([b]WarrantyDateExpires[/b] & "-" & 1)), "yyyy-mm") From [b]TableName[/b]
A date field always stores a full date, not just a year-month. You might have a form or report display only the year-month.tgraves8 said:Date field it has year-month