On Mon, 01 May 2006 09:17:58 -0700, "Richard Van Wasshnova"
<[EMAIL PROTECTED]> wrote:

>I would appreciate if someone could help me create an update query to get 
>the marriage date into the picture date, preferably as aflexible formatted 
>date

As you have discovered, the date in tblBR is not stored in the same
fashion as other Legacy dates. I don't know if there is a reason for
this ... a programmer will have to respond.

The tblBR date gets stored as a text field based on the Date Format
setting at the time the date is entered. Changing your Date Format later
does not affect dates already in tblBR. But if you go in later and
change the date in Legacy it will store the updated date in whichever
Date Format is currently selected.

So, in a nutshell, to do what you want as "a flexible formatted date" is
not possible.

-- 

Dennis M. Kowallek
[EMAIL PROTECTED]

******************
Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to 
Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter 
online at http://legacyfamilytree.com/FreeTrip.asp

Legacy User Group guidelines can be found at: 
http://www.LegacyFamilyTree.com/Etiquette.asp

To find past messages, please go to our searchable archives at: 
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/

For online technical support, please visit 
http://www.legacyfamilytree.com/Help.asp

To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp

Reply via email to