DataStore Monthly Reset

[zuoec (zuo)]

I’m trying to create a monthly leaderboard that resets the value for the leaderboard every month

local dateTable = os.date("*t", os.time())
local keyForMonth = "Y:"..dateTable["year"].." M:"..dateTable["month"]

local dataStoreService = game:GetService("DataStoreService")
local LeaderboardDataStore = dataStoreService:GetDataStore("LeaderboardDataStore" .. keyForMonth)

game.Players.PlayerAdded:Connect(function(player)

    local Leaderboard = Instance.new("IntValue",player)
    Leaderboard.Name = "Leaderboard"
    
    if player.Leaderboard.lastTimeDataStored ~= keyForMonth then
        player.Leaderboard.Value = 0
        player.Leaderboard.lastTimeDataStored = keyForMonth
    end
    
    local data 
    local success,errormessage = pcall(function()
        data = LeaderboardDataStore:GetAsync(player.UserId.."-Leaderboard")
    end)
    if success then
        Leaderboard.Value = data
    else
        print("There was an error while getting data")
        warn(errormessage)
    end
end)
game.Players.PlayerRemoving:Connect(function(player)
    local success,errormessage = pcall(function()
        LeaderboardDataStore:SetAsync(player.UserId.."-Leaderboard",player.Leaderboard.Value)
    end)
    if success then
        print("Data successfully saved!")
    else
        print("There was an error when saving data!")
        warn(errormessage)
    end
end)

How could I change/modify this, or would it even work at all?

[Mystery_Devx (IAmMyst)]

Just use a time function and wait a month and change the name of the data store automatically or just wipe all the data… tbh I don’t know what your planning with this but resetting datastore will make players mad and potentially ruin the game but it your game.

[Cosmental (Evelyn)]

Try this function.

function HasDayPassed(LastTick)
    return (tick() - LastTick) >= 2592000 --// 2592000 seconds are in a month of 30 days
end

[xZylter]

When you go to save the data just add a unique time identifer to the key. You can get the current time with os.time() and from there you get the current Month & Year. And then save that inside of the key alongside the player id. And then when you go to get the data for the datastore just use that month’s Month Number & Year.

I’m just gonna link this resource that explains the process, and as a suggestion to always search around before making posts.

How to make a simple global leaderboard

A Mathy Method @ForeverHD’s Method will work, but you can also utilize os.date to make your life a bit easier instead of doing a ton of math. os.date also factors in leap-days, daylight savings and such. A Easier Method Basically, what you do is instead of overwriting data, you just save and get it in a different key. That way, you don’t have to wory about past days or years or anything, you can just change the key. Using os.time and os.date, we make can make a unique key for the day, month, or…

[zuoec (zuo)]

When I call this function what should I put in the (LastTick) part?

[Cosmental (Evelyn)]

Your last saved tick.

So basically like so:

function HasMonthPassed(LastTick)
    return (tick() - LastTick) >= 2592000 --// 2592000 seconds are in a month of 30 days
end

print(HasMonthPassed(tick()))