If Sample_Date is a real date field, try:
Year ( Sample_Date ) & Right ( "00" & Month ( Sample_Date ) ; 2 ) & Right ( "00" & Day ( Sample_Date ) ; 2 )
Thanks for the code!!
I actually figured out the root cause of the issue- my computer calendar settings were changed, and the computer was giving M/D/YYYY instead of MM/DD/YYYY.