Avatar

Level 1

Thanks for the quick response.  Your suggestion did help but it'd broke another Date/Time field I have that calculates the day of the week based off the current date. The second field has another FormCalc script under the calcuate sections, which is shown below, I've tried moving it to different sections as you recommended with the other script but it's not working as expected. Any more suggestions?  Thanks.

if

(HasValue(workdate)) then

Num2Date( (Date2Num(workdate.formattedValue

, "MM/DD/YYYY") +0 ), "EEEE")

else

null

endif