LookupTrainingDate

Structure

LookupTrainingDate(sUsername)

Parameters

| Parameter | Type | Description
| SUserName | String | The employee to validate as trained |

Return Value

Date

Description

This function returns the date (if any) on which the sUserName employee was trained on the template that matches the current asset in the event. The current asset is determined by the selected record in the 'Choose Equipment' grid. If using a trigger action that loops through event equipment (like 'Event Finish'), then this function could be called once for each asset. Typically the sUserName is set to the user running the event, like:
 
dtTrainingDate = LookupTrainingDate(LookupCurrentUser)

if dtTrainingDate <> 0 then

ShowMessage('You were trained on ' & DateToStr(dtTrainingDate))

Else

ShowMessage('You are not trained on this template')

End If

Note: the use of this function assumes that Add/Edit Employees...Employee..Step 3 (Trainings - Per Template Name) details are being maintained in the IndySoft database. This detail table per employee logs the template upon which the employee is trained - with expiration dates, active state, etc.
 

Example

No example provided

Application Compatibility

IndySoft Calibration Management, IndySoft Commercial Lab Management, IndySoft Tool Management

Also See

No related topics |