go to post Drew Holloway · Mar 13, 2020 It says I'm not priveleged for this operation. But thanks for letting me know.
go to post Drew Holloway · Mar 3, 2020 Thanks for your reply. I'm just able to use SQL code and tables for this. I'm not sure if that was clear, but I don't have a way to insert or work with code like you had suggested. Thanks though!
go to post Drew Holloway · Mar 3, 2020 I'm just using SQL to get this result. I don't have a way to use other code.
go to post Drew Holloway · Feb 28, 2020 I created a Numbers table with a Numbers column. I manually entered data from 0 to 99. I was able to leverage this to give me my result...SELECT N1."Number" * 100 + N2."Number" AS NumFROM Numbers AS N1 CROSS JOIN Numbers AS N2This gives data up to 9999. I can easily add more rows if needed, but this should suffice for now.
go to post Drew Holloway · Feb 28, 2020 I believe I found the answer:SELECT DATEADD("D", "Number", '2017-01-01') FROM Numbers WHERE "Number" BETWEEN 0 AND DATEDIFF("D", '2017-01-01', '2017-04-05') Now I just need to expand my Numbers table. I'm wondering if anyone has a view for this. I'd like a numbers view between 0 and 10000. I think that should be sufficient. Feel free to answer here, but I'll start a new topic.
