Here is my code but i would like it to report Medium Date Medium Date.. the actual field and table format is medium date.
Code: between the" & " " &DateAdd("m", -1, Forms![TRHA]![Medical_Due_Subform].Form![Medical_Due]) & " " & "and" & " " & Forms![TRHA]![Medical_Due_Subform].Form![Medical_Due] _
Output: Between the 05/04/2021 and 05-May-21
I am trying to get output to Between the 05-Apr-21 and 05-May-21
Any guidance would be great.. thanks.
Code: between the" & " " &DateAdd("m", -1, Forms![TRHA]![Medical_Due_Subform].Form![Medical_Due]) & " " & "and" & " " & Forms![TRHA]![Medical_Due_Subform].Form![Medical_Due] _
Output: Between the 05/04/2021 and 05-May-21
I am trying to get output to Between the 05-Apr-21 and 05-May-21
Any guidance would be great.. thanks.