Quickbooks IIF Timestamp

  • Thread starter Thread starter Dominic Vella
  • Start date Start date
D

Dominic Vella

Does anyone know how to derive a Quickbooks Timestamp from the system date?

I've tried CInt(Date) however the number seems to appear different to the
one I've exported from quickbooks.

Rumour has it that it's the number of seconds from 1/1/1970. Can anyone
confirm that?

Thanks

Dom
 
Ok, well just for the record, my opinion is that
TIMESTAMP=DateDiff("s", "01/01/1970", Now)

I'm sure there's plenty of people that would wanna know, especially if
you're importing or exporting to/from quickbooks IIF files.

Feel free to pass on to me any other Quickbooks tips. I'd be interested.


Dom
www.effectivedata.com.au
 
Better to handle Quickbooks issues in Quickbook related newsgroups.
People looking for related lore will look there.

Better to keep these Access newsgroups focused on just Access.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access to quickbooks - looking for consulting help 4
Access and QuickBooks 8
Exporting into Quickbooks 7
Assistance dealing with duplicate items imported from Quickbooksneeded please. 2
export access database into quickbooks 3
How to export Access data to Quickbook? 4
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Exporting data from Quickbooks to Access 1

Back
Top