EssexBiker

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 !

Outcomes