I have a date field that has the Data Formatting of mm/dd/yyyy, which properly displays my values even when they're entered as m/d/yyyy. I have another field where I need to display this date as mmddyyyy as text. I have this field set up as a calculation and the calculation is Substitute ( MyDatabase::MyDateField; "/"; "" ). The problem is that this is returning a value like 841975 instead of 08041975, because it's taking the actual value of the field instead of the displayed value.
Is there anyway I can just grab the displayed value instead of having to fix all my entered dates, in whatever format they're in?