Log Without Seconds - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Log Without Seconds

Dan Pickle

2 years ago

I have 2 tables that get updated that have the =now() in the table. This is 2 separate log files that get automatically created. I would like to use that to match the 2 tables up to generate a form. Here is the rub. Even though both fields populate on the after update field the table is 2 seconds behind each other so the 2 date/time fields never match. I tried to put in a format of MM-DD-YYYY HH:NN into both fields however the =now() is still capturing the seconds so the fields do not match. Is there a way to have =now() NOT capture the seconds?

	Richard Rost @Reply 2 years ago
You COULD, but you still might catch records that are at 11:59:59 and then 00:00:01 that are two seconds apart but on completely separate DAYS. I'd look for a better solution. What's your goal?

	Richard Rost @Reply 2 years ago
BTW, to answer your question as it was asked, you could set the default value to: `=Date() + TimeSerial(Hour(Now()),Minute(Now()),0)` See TimeSerial for details. But I still don't think this is the best long-term solution.

	Richard Rost @Reply 2 years ago
And remember FORMAT isn't the data that's stored in the field. Now() will always STORE seconds. If you change the format, you're only changing the way that data is DISPLAYED.

	Dan Pickle OP @Reply 2 years ago
Thanks Richard, I am using the change log from this video https://599cd.com/blog/display-article.asp?ID=1339 and I want to tie the 2 tables together in a form so that you can see who made what changes when and I wanted to use the time\date field of both of the tables as the constant for the query that I am running for that form

	Dan Pickle OP @Reply 2 years ago
I tried to use the solution for the default value to be =Date() + TimeSerial(Hour(Now()),Minute(Now()),0) and it is still gathering the seconds in each respective field

	Dan Pickle OP @Reply 2 years ago
DOH! it might help if I changed the default value on the right field lol the -date formula worked!

	Richard Rost @Reply 2 years ago
Glad it worked... but I still think it's not the BEST solution to tie to records together light that. But if it works, it works... until it doesn't. LOL

	Dan Pickle OP @Reply 2 years ago
there is ALWAYS the "until it doesn't" lol :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View