NEED FMS IN OHEM Absence Table

[Former Member]

Hi experts

i need a fms to be attached in OHEM -Absences Table (HEM1).

Date From -  To = Total Days

01/08/2015 - 10/08/2015  = 10 days

to get this 10 days in the Total Days i need a FMS

Regards

[Former Member · Accepted solution]

Hi Shams,

Try this query

Select datediff(d,$[hem1.fromDate.date] - $[hem1.toDate.date],0) +1

[Former Member · Accepted solution]

Hi Raja

Thnks for the support, its fine working

[former_member205766]

Hi Shahan

Try the below FMS Query

SELECT datediff(d,$[hem1.fromDate.number] - $[hem1.toDate.number],0) as days

With Regards

Balaji Sampath