AnsweredAssumed Answered

How to get the displayed value of a field?

Question asked by dwirony on Oct 23, 2018
Latest reply on Oct 23, 2018 by dwirony

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?

Outcomes