rtdc Registered User. Local time Today, 19:27 Joined Feb 27, 2007 Messages 55 Jan 9, 2008 #1 Hi Anyone out there have some code to convert a access now() field to a unix timestamp? Cheers.
KeithG AWF VIP Local time Today, 11:27 Joined Mar 23, 2006 Messages 2,592 Jan 9, 2008 #2 What does a Unix timestamp look like?
rtdc Registered User. Local time Today, 19:27 Joined Feb 27, 2007 Messages 55 Jan 9, 2008 #3 Should be the time in seconds since midnight of January 1, 1970 Theres probably an easy way of doing this but I can't see at the moment.
Should be the time in seconds since midnight of January 1, 1970 Theres probably an easy way of doing this but I can't see at the moment.
R raskew AWF VIP Local time Today, 13:27 Joined Jun 2, 2001 Messages 2,734 Jan 9, 2008 #4 Should be able to use the DateDiff() function, e.g. y = datediff("s", #1/1/1970#, now()) ? y 1199871014 Bob
Should be able to use the DateDiff() function, e.g. y = datediff("s", #1/1/1970#, now()) ? y 1199871014 Bob
rtdc Registered User. Local time Today, 19:27 Joined Feb 27, 2007 Messages 55 Jan 9, 2008 #5 Nice one Bob that did the job loverly, thanks.
