jreed

Date to Text?

Discussion created by jreed on Jan 2, 2017
Latest reply on Jan 2, 2017 by user19752

I use dates converted to text in several Tables. The dates are part of a text string used in different relationships.The dates are converted using the GetAsText (data).  There are several Tables that use the date in a string as a relationship. The 1st of January converted the date in two different ways.

I some Tables the date was converted as "01/01/2017" in others it is converted as "1/1/2017".

 

I am running Filemaker Server 14 on a 2012 Server.

 

What causes the date to convert differently?

Outcomes