Originally Posted by
Ajax
Access equivalent of the Excel Text function is Format.
Access equivalent of the Excel Today() function is Date().
so it translates to
=Format(Date()-WeekDay(Date()),"m/d/yy")
But not sure why you need a text representation of the date (format converts the date numerical value to text)- it won't sort in date order for example. Adding 0 will not convert it to a number
As with excel, dates are a special form of number which can be formatted to whatever date format you require. You can use the format property of a field or control to show dates as you want without converting it to text
today (3rd December) is 42707, tomorrow will be 42708 and yesterday was 42706
and now (17:57) is 0.7483564815 which is the number of seconds so far this day divided by the number of seconds in the day (86400)
if you use the access now() function, it returns the number 42707.7483564815