I have a labor record for employees where we record the hours worked associated with a week number. The week number is formatted as a numeric field.
What I am looking to do is have an unbound control where the date is entered, (like week ending date), have it return "ww" week number format and it becomes the default input for the records that follow.
I am a novice and do not know how to turn a date format result into a number format in another field.
unbound field in header = [weekEnding] ; basically date() ww
bound field = [tblEmployeeHours_WeekNo] ; format number