AnsweredAssumed Answered

Text date problem

Question asked by mplt on Oct 24, 2014
Latest reply on Oct 24, 2014 by TSGal

Summary

Text date problem

Product

FileMaker Pro

Version

13v3

Operating system version

Windows 7 64 bits

Description of the issue

I have a issue with a text field from MS-SQL using ODBC.
When I look at this field within the data viewer "MonthName(GetAsDate( dbo.PIPPROJECT3 Details::dateInText )) in a layout, the result is "?". As soon as I open the field (it's a drop-down calendar), the value show correctly "april". Removing the GetAsDate() doesn't change anything. If I look at the plain field, I always have "2013-04-30", no matter if I click the drop-down calendar or not. Looking in MS-SQL the text date is formated correctly "AAAA-MM-DD".

Why?

Expected result

"april"

Actual result

"?"

Exact text of any error message(s) that appear

none

Configuration information

The text date is drop-down calendar with no formating (as entering) and I can't change it.

Workaround

None

Sans_titre.png

Outcomes