Help

Adding Datetime Format

Topic Labels: Formulas
Solved
Jump to Solution
774 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Yvia
6 - Interface Innovator
6 - Interface Innovator

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).

Yvia_1-1683072589309.png

 

 

 

1 Solution

Accepted Solutions
aleaja
6 - Interface Innovator
6 - Interface Innovator

@Yvia  try something like this:

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

 

See Solution in Thread

4 Replies 4

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?

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

aleaja
6 - Interface Innovator
6 - Interface Innovator

@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
6 - Interface Innovator
6 - Interface Innovator

You are awesome!!! Thank you!