cancel
Showing results for 
Search instead for 
Did you mean: 

NEED FMS IN OHEM Absence Table

Former Member
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

Hi Shams,

Try this query

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

Former Member
0 Kudos

Hi Raja

Thnks for the support, its fine working