You can use these date, timestamp, and number format strings in your transformation column formulas.

See Anaplan Data Orchestrator functions for the types of functions and formats you can use in your column formulas.

## Date and timestamp format string

Date or Time Part | Description |

D | One or two digits day between 1 and 31. |

DD | Two digits day between 01 and 31. |

DDD | Abbreviated day of the week: Mon, Tue, and so on. |

DDDD | Day of the week name: Monday, Tuesday, and so on. |

W, WW | One or two digit ISO week number between 1 and 53. |

M | One or two digit month between 1 and 12. |

MM | Two digit month between 01 and 12. |

MMM | Abbreviated month name: Jan, Feb, and so on. |

MMMM | Month name: January, February, and so on. |

Y, YY, YYY, YYYY | One, two, three, and four digit year. |

H, HH | One or two digit hours (24 hours). |

h, hh | One or two digit hours (12 hours). |

m, mm | One or two digit minutes. |

s, ss | One or two digit seconds. |

f | Fractions of seconds. |

p, P | Lower or uppercase meridian indicators: am, pm, AM, PM. |

z | Timezone name: PST (string needs to be cast to timestamp/timestamptz to use timezone format). |

Z | Timezone offset: -08:00 (string needs to be cast to timestamp/timestamptz to use timezone format). |

## Number format string

Format | Description |

9 | Numeric value with the specified number of digits. |

0 | Numeric value with leading zeros. |

. (period), D | Decimal point. |

, (comma) | Thousands separator. |

CC | Century code. For example, the 21st century started on 2001-01-01 (supported for TO_CHAR only). |

FM | Fill mode. Suppress padding blanks and zeroes. |

PR | Negative value in angle brackets. |

S | Sign anchored to a number. |

L, $ | Currency symbol in the specified position. |

G | Group separator. |

MI | Minus sign in the specified position for numbers that are less than 0. |

PL | Plus sign in the specified position for numbers that are greater than 0. |

SG | Plus or minus sign in the specified position. |

RN | Roman numeral between 1 and 3999 (supported for TO_CHAR only). |

TH or th | Ordinal number suffix. Doesn't convert fractional numbers or values that are less than zero.. |