Good night, who will tell you how to convert the number 1.5 to the date format using ACCESS? That is, 1.5 is a year and a half. In the future, this converted date must be added to the date of the normal view (01/01/1960) and get 01/07/1961
Thank you in advance

    2 answers 2

    1. 1 year = 365 days
    2. the current date is cast to unixtime
    3. add the number of days (1.5 * 365)
    4. translate unixtime to the current date

      There is a dateadd function. The increment must be integer, so you can use the months: DateAdd ("m", 18, [date])