Year-Month Reference Field
I have a table called Orders. Fields include Creation Date (YYYY-MM-DD), Total Revenue, and Total Refunded for each customer's order. I need to create a new table to sum the Total Revenue and Total ...
Forum Discussion
I Suggest at you use excel to create at least 10 years (120 records) with a text field in the format YYYY-MM
For Example
2021-03
Import that into a table and set that field as the key field.
Then on the details side, make the formula
List("-", totext(year([Creation Date (DD-MM-YYYY)])),
padleft(totext(Month([Creation Date (DD-MM-YYYY)])),2,"0"))
Make a Relationship back to the YYYY-MM Months table.
post back if that formula does not work due to syntax errors.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
For Example
2021-03
Import that into a table and set that field as the key field.
Then on the details side, make the formula
List("-", totext(year([Creation Date (DD-MM-YYYY)])),
padleft(totext(Month([Creation Date (DD-MM-YYYY)])),2,"0"))
Make a Relationship back to the YYYY-MM Months table.
post back if that formula does not work due to syntax errors.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Formula worked, thanks! And I created the excel file, imported, and connected the two tables.
Thanks for your help! Much appreciated!
------------------------------
Kevin BP
------------------------------
Thanks for your help! Much appreciated!
------------------------------
Kevin BP
------------------------------
