Date Time Variable Options

Date Time Variables can enhance your query and file date templating and variable options. This allows easier scheduling and programmatic templating for common date variables.

Key Function
${rd} Replaces with -rd values in CMD. For example, 2023-01-20.
${rdEnd} Replaces with -rdEnd values in CMD.
${yyyy} Replaces with 4-digit year portion of -rd values in CMD. For example, 2023.
${yy} Replaces with 2-digit year portion of -rd values in CMD. For example, 23.
${M} Replaces with 1-digit month portion of -rd values in CMD.
${MM} Replaces with 2-digit month portion of -rd values in CMD.
${MMM} Replaces with 3 letter month name portion of -rd values in CMD For example, Jan, Jul, Dec.
${MMMM} Replaces with long month name portion of -rd values in CMD For example, January, July, December.
${d} Replaces with 1 digit day portion of -rd values in CMD.
${dd} Replaces with 2 digit day portion of -rd values in CMD.
${HH} Replaces with 2 digit hour portion of -rd values in CMD.
${KK} Replaces with 1 digit hour portion of -rd values in CMD.
${mm} Replaces with 2 digit minute portion of -rd values in CMD.
${ss} Replaces with 2 digit second portion of -rd values in CMD.