Reply To: Date format in report csv output

Home Forum Reporting Date format in report csv output Reply To: Date format in report csv output

#6967

The┬ new functions, GetExactDay, GetExactMonth and GetExactYear were part of an update. In lieu of the update you could use some helper fields and behaviors to set a field with the full date including zeros. Set the day in a day helper field. If the field length = 1 use a Set Field with a formula (0 + d + day). Then use another set field to set the Day helper with a replace function. Replace d in the field. leave it blank so it replaces d with nothing. Do the same with the month field. Then put them together in a formula (day + / + month + / + year).