Skip to main content

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

 

 

 

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?

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’)?

@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  try something like this:

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

 


You are awesome!!! Thank you!

Reply


Terms & Conditions