Data Synchronisation StudioUser GuideCalculated ColumnsFunctionsDAYOn this pageDAY Returns the day of the month value of a DateTime. Syntax int? DAY(DateTime? value) Example DAY(TODAY()) Will return the day value of today's date e.g. 28 or 2. Alternatively you can use a DateTime column from your data source for example OrderDate: DAY(OrderDate)