[AccessD] Excel Data Dump

[Rocky Smolin]

I have another simple export to excel filtered by the property that's being
displayed.  No problem with the date format.  But I eliminated the date
format from the file name.  Still craps out.

I've had this problem before referencing a query in a transfer spreadsheet
command, and worked around it by substituting the SQL string itself.  This
time, there's too many fields to accommodate the SQL in a string.

brst,

r

Thanks

r

On Wed, Mar 30, 2022 at 10:02 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> am/pm and AM?PM force the time to be displayed as 12 hour times.
>
> HH says to use leading zeros,
>
> so 2:00 pm (14:00) would display as
>
> 03-31-22 02_52_00 PM
> Personally, I always use ISO8601 instead of region specific formats.  That
> way, files sort
> correctly by date and you don't get potentially problematic spaces in file
> names.
>
> I'd use:strDT = Format(Now, "YYYYMMDDTHHMMSS") & ".xls"
>
>
> On 31 Mar 2022 at 3:28, Paul Hartland via AccessD wrote:
>
> > Hi Rocky,
> >
> > Just an idea what does strfilename produce, you have the datetime
> > format to show am/pm yet the hours are 24 hour when using capital HH
> > so not really required anyway, but apart from that when the debug
> > passes strfikename have you looked at it ?
> >
> > strDT = Format(Now, "MM-DD-YY HH_MM_SS AM/PM") & ".xls"
> >     strFileName = gstrFrontEndPath & "Property_Tenant_Data_Dump_" &
> >     strDT
> >
> > Paul
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>