Forum Discussion
Solved
need help
i need some help with some date colum. i have a enquete that will be filled on month base. now if someone fills the enquete in februari his answers are for the previous month so for Januari. i ...
NewColumn = EDATE([date],-1)
MONTH(EDATE([date],-1))
This gives me back the numbers of the month the result is oke but i want to make it a date colum so i can place a relation with a calender table
NewColumn = EDATE([date],-1)