+3I 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).
Best answer by aleaja
@Yvia try something like this:
DATETIME_FORMAT(
TODAY(),
'MMM'
)
&" sales: "
&{Sales this month}
&" ("
&DATETIME_FORMAT(
DATEADD(
TODAY(),
-1,'month'
),
'MMM'
)
&" sales: "
&{Sales last month}
&")"
+31Does 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?
+3Does 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’)?
+5@Yvia try something like this:
DATETIME_FORMAT(
TODAY(),
'MMM'
)
&" sales: "
&{Sales this month}
&" ("
&DATETIME_FORMAT(
DATEADD(
TODAY(),
-1,'month'
),
'MMM'
)
&" sales: "
&{Sales last month}
&")"
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.