Adding Datetime Format

[Yvia]

I have three columns: 1st is the Sales Last Month, 2nd is Sales This Month and 3rd one shows the ratio of the two columns. I want to add the DateTime format so Sales Field will look - Sales: 137/150 (Apr: 201/200) instead of Sales: 137/150 (201/200).

[TheTimeSavingCo]

Does this record contain a field with a Date field that contains the date time you'd like to format?  Could you provide a screenshot of the whole record?

[Yvia]

There's no field date in this table. Is it still possible by adding using DATETIME_FORMAT(DATEADD(TODAY(),-1,‘month’),‘MMM’)?

[aleaja · Accepted solution]

@Yvia  try something like this:

DATETIME_FORMAT(
  TODAY(),
  'MMM'
)
&" sales: "
&{Sales this month}
&" ("
&DATETIME_FORMAT(
  DATEADD(
    TODAY(),
    -1,'month'
  ),
  'MMM'
)
&" sales: "
&{Sales last month}
&")"

[Yvia]

You are awesome!!! Thank you!