Advertisement

07.01.2008 at 06:52AM PDT, ID: 23530111
[x]
Attachment Details

add leading zeros to raw date data

Asked by Eroots in FileMaker Pro Database

Tags: filemaker

I am trying to import old data into a new system, the new system requires date data to be in 00/00/0000 format, but the raw data has some that are 0/0/0000 with missing leading zeros.

Is there any way to perform a quick calc function or the like to add those zeros? The date is part of a calculation field that generates a unique ID that is used for a relationship to another table, without the extra zeros, the keys are not matching.Start Free Trial
[+][-]07.01.2008 at 08:18AM PDT, ID: 21908630

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.01.2008 at 09:39AM PDT, ID: 21909358

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: FileMaker Pro Database
Tags: filemaker
Sign Up Now!
Solution Provided By: billmercer
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.01.2008 at 11:39AM PDT, ID: 21910345

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2008 at 11:16AM PDT, ID: 21919098

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2008 at 12:15PM PDT, ID: 21919663

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628