Role21

Hi,   I am using this formula to get the month in the specific Date field:
(DatePart(month, [@field:date]))
And the result of this formula is the number of the month but what I want is the month name for the result to display.    Is there a way to do this? 

Hi there, I think Datediff formulas does work on formula fields, except if you are using GetDate().
Datediff will work if the dates are deterministic (static). So if you're just computing for how many minutes were spent between start time and end time, DateDiff(minutes, starttime, endtime) should work in the Formula datatype. 

This is very helpful! 

Hi @Role21,
 
Thank you for your response. You can concatenate fields using this formula. You need to convert the DataTypes of your fields to varchar using CAST  function. You can refer to this link: https://howto.caspio.com/function-reference/

 
Hope this helps,
 
Regards,
kristina

Hi Role21,
Kristina is correct, you need to use "CAST" in your formula so you can convert your Data Type  as a VARCHAR.
If you do not convert that, the Data Types are still Integer, so the values add up.
 
-JolliBeng

Hi,
Just want to add some additional resources to this old post. Here are some Howto Documentation that I've used in building and modifying my tables:
https://howto.caspio.com/tables-and-views/creating-and-modifying-a-table/
https://howto.caspio.com/tables-and-views/modifying-a-tables-design/
https://howto.caspio.com/tables-and-views/table-and-database-design/
 
Hope that helps.
 
Regards,
@NailDyanC

Hello Role21,
You can also change the icon for the Bulk Edit in Styles. Just go to you Style>Results Page> Page Actions> Toolbar Image Actions

 
Hope this helps.
 
-JolliBeng