calc' based on records within the current calendar year

Discussion created by EssexBiker on May 2, 2016
Latest reply on May 3, 2016 by alquimby

So, my lovely FM Buddies:


  • Holiday date  [Date Field]
  • Holiday Value [Number Field ]       // A day booked would usually be 1 but could be a half day ( 0.5)


I wish to calculate the sum of the Holiday value, but only if that falls within the current calendar year  01 Jan to 31 Dec ( sorry to my dear friends across the pond , 1/1/ - 12/31 ... ( Shudder)


I have a feeling that I should be using a GET YEAR type thingy


My head is fried, it's been a long but productive FM weekend


As always, I'd be most grateful for any suggestions.


Isn't FM Pro 14 Advanced marvelous by the way


Michael  x


Message was edited by: Michael Greenway


Message was edited by: Michael Greenway edited  a typo !