Stamp Date and Time Automatically

[PATNAS01]

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]

Set the default on that field to Now()

 

[PATNAS01]

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]

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]

Where did you put Now()? and what field type is it? Can you post a screenshot?

 

[MarkK]

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]

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]

Pasting is not your best option for transferring data from Excel. How about using TransferSpreadsheet?

 

[PATNAS01]

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]

we're happy you solved it.