| 
       << Click to Display Table of Contents >> Navigation: Reference > Transforms > Stamp | 
    
Description
Adds a stamp with time, date and other information as a new row or a new column.
Add the current date to the end of each row:

One.
•Supply the stamp format in Format (see below).
Format  | 
Meaning  | 
|---|---|
d  | 
The day as number without a leading zero (1 to 31)  | 
dd  | 
The day as number with a leading zero (01 to 31)  | 
ddd  | 
The abbreviated localized day name (e.g. 'Mon' to 'Sun'). Uses the system locale to localize the name.  | 
dddd  | 
The long localized day name (e.g. 'Monday' to 'Sunday'). Uses the system locale to localize the name.  | 
M  | 
The month as number without a leading zero (1 to 12).  | 
MM  | 
The month as number with a leading zero (01 to 12)  | 
MMM  | 
The abbreviated localized month name (e.g. 'Jan' to 'Dec'). Uses the system locale to localize the name.  | 
MMMM  | 
The long localized month name (e.g. 'January' to 'December'). Uses the system locale to localize the name.  | 
yy  | 
The year as two digit number (00 to 99).  | 
yyyy  | 
The year as four digit number. If the year is negative, a minus sign is prepended in addition.  | 
h  | 
The hour without a leading zero (0 to 23 or 1 to 12 if AM/PM display).  | 
hh  | 
The hour with a leading zero (00 to 23 or 01 to 12 if AM/PM display).  | 
H  | 
The hour without a leading zero (0 to 23, even with AM/PM display).  | 
HH  | 
The hour with a leading zero (00 to 23, even with AM/PM display).  | 
m  | 
The minute without a leading zero (0 to 59).  | 
mm  | 
The minute with a leading zero (00 to 59).  | 
s  | 
The whole second without a leading zero (0 to 59).  | 
ss  | 
The whole second with a leading zero where applicable (00 to 59).  | 
z  | 
The fractional part of the second, to go after a decimal point, without trailing zeroes (0 to 999). Thus "s.z" reports the seconds to full available (millisecond) precision without trailing zeroes.  | 
AP or A  | 
The fractional part of the second, to millisecond precision, including trailing.  | 
ap or a  | 
Use am/pm display. a/ap will be replaced by either "am" or "pm".  | 
t  | 
The timezone (for example "CEST").  | 
$(c)  | 
The computer name.  | 
$(f)  | 
The path of the .transform file, e.g. C:\Users\andy\Desktop\mytransform.transform  | 
$(u)  | 
The name of the user (from the USER or USERNAME environment variable).  | 
•Select from Position whether you want the stamp row added to the start or end of the dataset or to every row in a new column.
•If you add the stamp to Every Row you can move the column using Reorder Cols.
•The Format text is case-sensitive.