Hello all!
(RS V4.2, ADP SQLBase)
I have a simple Macro-Derived Field to format termination dates into the "Medium Date" format. The code is as follows:
I'm using syntactically identical code to reformat the HireDateActual, with success.
The TERMINATIONDATEROE Field is Null for many employees.
The output is "<Error>" for ALL employees, even those who actually have a value in that field.
I tried putting:
into the macro, but with the same result (<Error>).
Any Ideas?
Many Thanks!
(RS V4.2, ADP SQLBase)
I have a simple Macro-Derived Field to format termination dates into the "Medium Date" format. The code is as follows:
Code:
Sub TermDate2()
Dim TermDt
TermDt = Field("TERMINATIONDATEROE")
Dim TermDt2 as string
TermDt2 = Format$(TermDt, "Medium Date")
DerivedField Field$("TERMINATIONDATEROE")
End Sub
I'm using syntactically identical code to reformat the HireDateActual, with success.
The TERMINATIONDATEROE Field is Null for many employees.
The output is "<Error>" for ALL employees, even those who actually have a value in that field.
I tried putting:
Code:
If TermDt = "" Then
DerivedField "-"
Exit Sub
End If
into the macro, but with the same result (<Error>).
Any Ideas?
Many Thanks!