 Samir says, hey guys, I'm trying to calculate the dates in a SharePoint list, but can't get my head around it. I have a new item for an example added to the list where it shows what date and time it was logged on. My request is to create another two columns where one column will fetch how long since the new item was opened and another column since how long since the item was modified. Anyone have any thoughts of a simple syntax for the formula? Because talking about collaborating on syntax, it makes for great video with no graphics. I did put a link in the spreadsheet that has all of the common formulas that you might use. For those, the biggest challenge I found is using the current date because the formula that you have to use in the syntax for SharePoint lists, the column names are in square brackets and the today callout is in square brackets. It's looking for a column called today and it can't find it, but I think I just recently found that they fixed that. You can use the today with the parentheses, the same function that you use in Excel, but I use the Excel date functions as my cheat sheet for everything because they all work the same in SharePoints. If you can test it in Excel, it usually works in the SharePoint, a.k.a. Microsoft lists, which were really SharePoint lists to begin with, just Anne. You should have a better marketing department now. Yeah, exactly. I just love it when they're like, new thing, Microsoft lists. I'm like, yeah, welcome to my world. It's been around for 20 years, whatever. Just had a little shiny, pretty face, you know, a bit of makeup put on it. And a brand new little icon, right? Yeah. So in 30 years, Sherry, 30 years. Yeah. Oh, yeah. Quit making me old Christian. I was thinking about the same thing. Not about you being old, Sherry. But we're seasoned. Well, seasoned. A cast iron skillet. Well, the other thing I would say that a lot of people writing about talking about using chat GPT for this same thing to go in and and add the narrative in there and say, create the syntax for this. So I don't play in that space. I'm not doing that. But on the accuracy of that joy, you have your hand up. I call on you. I need to make a comment about that. Yeah, be careful. Check chat GPT's work. A dear marketing friend of mine just for fun Z said, I'm going to have chat GPT write a team's blog. It made so much stuff up. Let me just flat out wrong. She's like, edit this and get it back to me. That page was bleeding red. Now, I know you can go in and have it right as certain personas. But yes, check your work. Check your work. Well, think about it. Chat GPT is being trained by the internet. And we all know everything on the internet is true and accurate. Of course. So, yeah, so if it's basing it on what's out there as being with the assumption that is true and accurate, what it pulls back is not going to be that true. I heard that Bill Gates is going to send $1,000 to anyone who can find errors in chat GPT. So. Oh, let me go find that original version of that blog. Great. I'm joking, of course, people. It's not not true. Yeah, but that is on the internet. Yeah, gotta be true. But I'll play devil's advocate for chat GPT. When it comes to creating what are these things called calculated columns and SharePoint lists with these formulas. I am not an expert at this stuff. So I wouldn't say it's simple syntax. Maybe conceptually it is if you've got a lot of experience with it. But if you're new to it, I'm going to chat. Gbt every day of the week to get a head start. Well, that's why he's Googled it. Yes, well, a lot of it too. Well, but that's that's another reason why I mean if you pull create the syntax from it, you're going to go and test that as well and verify that. So you need to verify, verify, verify anything coming out of chat GPT. I didn't mean to take it sideways into an AI discussion, but no, but it's a good one because people are thinking chat. Gbt is the new magic wand for everything. You know, love your son. You've got everything you need. It's like, no, that's not that's not love. You say love your side. Got to say. Yeah, it's not everyone's going to get those references. But it is a good job. Come on. Very popular. You know, it's Harry Potter. I know it. Given it folks a bad name with all of these cultural references. Yeah. Yeah, I thought you were I I thought you were my peeps. I thought I was in with my peeps. There is no safe space.