Date format in MLS 3.1.0

Discussions around using and interfacing with the Church MLS program.
Locked
RossEvans
Senior Member
Posts: 1345
Joined: Wed Jun 11, 2008 9:52 pm
Location: Austin TX
Contact:

Date format in MLS 3.1.0

#1

Post by RossEvans »

Has the standard date format in MLS changed, or has it always been displayed without leading zeros?

In v 3.1.0, the leading zeros were dropped from the four date fields of the Membership.csv export file. For example, what was "04 Dec 2007" in prior versions is "4 Dec 2007" in MLS 3.1.0 exports.

Is this a change in the overall date style of MLS, or is the export format being brought into compliance with a display format that was always used in reports and screen displays?
russellhltn
Community Administrator
Posts: 34384
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

#2

Post by russellhltn »

I checked a Membership.csv I did under 3.0.3 - it has leading zeros.

Just to check the obvious - you did look at the file straight out of MLS and not after it's been touched by Excel or Calc?
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
RossEvans
Senior Member
Posts: 1345
Joined: Wed Jun 11, 2008 9:52 pm
Location: Austin TX
Contact:

#3

Post by RossEvans »

RussellHltn wrote:I checked a Membership.csv I did under 3.0.3 - it has leading zeros.

Just to check the obvious - you did look at the file straight out of MLS and not after it's been touched by Excel or Calc?
Yes, I have all the raw MLS exports for 3.0.3 and 3.1.0.

I have no doubt about the facts as they relate to the export files. My question is whether the format changed elsewhere in MLS -- the reports, screens, etc. -- or whether these displays have always dropped the leading zeros.
User avatar
aebrown
Community Administrator
Posts: 15153
Joined: Tue Nov 27, 2007 8:48 pm
Location: Draper, Utah

#4

Post by aebrown »

boomerbubba wrote:Yes, I have all the raw MLS exports for 3.0.3 and 3.1.0.

I have no doubt about the facts as they relate to the export files. My question is whether the format changed elsewhere in MLS -- the reports, screens, etc. -- or whether these displays have always dropped the leading zeros.
MLS has always dropped the leading zeroes in the display. But you are correct that the export files used to have leading zeroes on dates prior to MLS 3.1, but now they don't.
Locked

Return to “MLS Support, Help, and Feedback”