Forum Discussion

Krijgersss's avatar
Krijgersss
Icon for Helper II rankHelper II
2 years ago
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 ...
  • lbendlin's avatar
    lbendlin
    2 years ago

    NewColumn = EDATE([date],-1)

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

MONTH(EDATE([date],-1))

Krijgersss's avatar
Krijgersss
Icon for Helper II rankHelper II
2 years ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    NewColumn = EDATE([date],-1)