DateDiff to beginning of next financial year

[handlebarry]

Hi,

Trying to work out the difference between a given date and the start of the next financial year (April 1st)

AXB Addition: DateDiff("d",[LHFH_Start_Date],"THE NEXT APRIL 1st")

Can someone please help - thanks

 

[Remou]

Perhaps:
[tt]The Next April the 1st = Iff(Month([LHFH_Start_Date])>3,DateSerial(Year([LHFH_Start_Date])+1,4,1),DateSerial(Year([LHFH_Start_Date]),4,1))[/tt]

 

[handlebarry]

thanks very much Remou