Stamp Date and Time Automatically (1 Viewer)

PATNAS01

New member
Local time
Today, 18:50
Joined
Nov 30, 2017
Messages
4
Hi Friends,

I have created a table where I will be pasting multiple lines in that table containing some details. How can I get the Date and Time stamp for each line every time when I paste the lines/records.

Thanks,
PATNAS01
 

plog

Banishment Pending
Local time
Today, 08:20
Joined
May 11, 2011
Messages
11,611
Set the default on that field to Now()
 

PATNAS01

New member
Local time
Today, 18:50
Joined
Nov 30, 2017
Messages
4
I tried both Now()and Date() but that field still returns as blank. I repeat, I am pasting multiple records in table after copying from excel sheet.

Please help.

Thanks,
Sesagiri
 

PATNAS01

New member
Local time
Today, 18:50
Joined
Nov 30, 2017
Messages
4
I tried both Now()and Date() but that field still returns as blank. I repeat, I am pasting multiple records in table after copying from excel sheet.

Please help.

Thanks,
PATNAS01
 

plog

Banishment Pending
Local time
Today, 08:20
Joined
May 11, 2011
Messages
11,611
Where did you put Now()? and what field type is it? Can you post a screenshot?
 

MarkK

bit cruncher
Local time
Today, 06:20
Joined
Mar 17, 2004
Messages
8,178
Also, maybe you are pasting over that field's value. If you are copying multiple columns from excel, and your date field is in the middle of that range, and the value in the excel file is blank, maybe that blank value is overwriting your default date.

To test it, open the table and scroll down to the very last (new) row. Default values will appear there, before the row is added to the table.

hth
Mark
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:20
Joined
May 7, 2009
Messages
19,169
create a Data macro, Before Change.

Setfield: [yourDateField]
value: Now()

so whether your date field is overwritten or not on your pasting, that field is still updated by the current date time.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:20
Joined
Feb 19, 2002
Messages
42,970
Pasting is not your best option for transferring data from Excel. How about using TransferSpreadsheet?
 

PATNAS01

New member
Local time
Today, 18:50
Joined
Nov 30, 2017
Messages
4
create a Data macro, Before Change.

Setfield: [yourDateField]
value: Now()

so whether your date field is overwritten or not on your pasting, that field is still updated by the current date time.

Fantastic, it did magic. I am getting the current date and time. Thank you arnelgp.

Thank you all once again. You guys are fantastic:):)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:20
Joined
May 7, 2009
Messages
19,169
we're happy you solved it.
 

Users who are viewing this thread

Top Bottom