[AccessD] 3 Dates Questions

Darryl Collins darryl at whittleconsulting.com.au
Sat Nov 5 17:55:21 CDT 2016


"To your last question: Use the ISO sequence, yyyy-mm-dd, which nowhere can be misread"

Strongly recommend using the approach above when dealing with any dates.

Cheers
Darryl.



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Sunday, 6 November 2016 9:21 AM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] 3 Dates Questions

Hi Kathryn

To your first question: Set the Format property to: dd mmm yyyy.

To your last question: Use the ISO sequence, yyyy-mm-dd, which nowhere can be misread.

/gustav



________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Kathryn Bassett <kathryn at bassett.net>
Sendt: 5. november 2016 22:32:29
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] 3 Dates Questions

On my computer, I have dd MMM yyy as the short date format, and dddd, dd MMM yyyy set for the long date format; so the long date for the header is working correctly to include the day of the week. What I'm trying to accomplish is to make a date show up as, for example, 19 Oct 1778 on someone else's computer instead of 10/19/1778.  At the very least have it as Oct 19, 1779. We need the month name, not numbers, because otherwise how does one tell if 3/5 is Mar 5 or May 3? You have to have the month name in genealogy.
Kathryn

> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Gustav Brock
> Sent: Saturday, 05 Nov 2016 12:03 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] 3 Dates Questions
>
> Hi Kathryn
>
> You have specified "Long date" for the one field, but no (blank) 
> format
for
> the other.
>
> /gustav
>
> ________________________________________
> Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af 
> Kathryn Bassett <kathryn at bassett.net>
> Sendt: 5. november 2016 19:01:58
> Til: 'Access Developers discussion and problem solving'
> Emne: [AccessD] 3 Dates Questions
>
> https://www.dropbox.com/s/1akv3zu8jvxf4e9/MarriageIndex.accdb?dl=0
> Question has to do with this report, and any others I might make:
> ReportBasedOnqryGroomOrder
>
> Q 1) When I open the report, the header date shows as Saturday, 05 Nov
> 2016 and Alexander Hugh's date shows as 19 Oct 1778. When my friend 
> opens it, Alexander's date shows as 10/19/1778 (all dates show that way).
I'm
> sure it has to do with the way I have my computer's dates set. Is 
> there a
way
> to force dates in reports to show up dd MMM yyyy, regardless of the 
> way the system is set up?
>
> Q 2) Same report. In the table, the Notes field is set as a memo, and 
> the
form
> has the scrollbar to see all of the field. Scroll down to Chadwick for 
> my example. I put a bunch of garbage in the notes field. How do I make 
> the report expand/contract to be the size needed?
>
> Q3) See ! Sample entry where I need to enter *just a year* in the date
field
> so I can put "2nd month, 9th day" in the notes when Quaker marriage 
> dates are encountered. Besides Quaker dates, sometimes all I have is a year.
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my bag" "GH is 
> my soap"
> kathryn at bassett.net
> http://bassett.net
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list