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
Andrey Stifurak Andrey Stifurak
130 1 golden mark 2 silver marks 15 bronze marks
|
2 answers
- 1 year = 365 days
- the current date is cast to unixtime
- add the number of days (1.5 * 365)
- translate unixtime to the current date
akalend akalend
949 6 silver marks 13 bronze marks
|
There is a dateadd function. The increment must be integer, so you can use the months: DateAdd ("m", 18, [date])
msi msi
11k 11 silver marks 16 bronze marks
|