|between 2 dates in access query||1.1||0.1||8451||77|
you need to use the duration functions: https://docs.microsoft.com/en-us/powerquery-m/duration-days =each Duration.Days([Date1] - [Date2])How do I get the current date in access?
from datetime import date today = date.today () print("Today's date:", today) Here, we imported the date class from the datetime module. Then, we used the date.today () method to get the current local date. By the way, date.today () returns a date object, which is assigned to the today variable in the above program.