lua table range of dates

[benanderson_475]

How can i create a lua table of the last dates and days for the previous 14 day period, starting at today?  
I want to end up with {day 1 = {date = "8/19/2020", day = "wednesday"}, day_two = {date = "7/19/2020", day = "Tuesday"}....... }

i started with 

Code:

1234567891011

t = os.date("*t") data ={} today = os.date('%w') --%w weekday (3) [0-6 = Sunday-Saturday] Index  = 1 for i = 1, 14 do data[i] = today -Index Index = Index+1 end

how can i filter out the -ve values and make it circular 0-6  to line up with the %w pattern

[admin]

You need to use modulo (%) operator for this:

Code:

12345678

data = {} today = os.date('%w') for i = 1, 14 do   data[ i ] = (today - i) % 7 end log(data)

[benanderson_475]

You need to use modulo (%) operator for this:

Code:

12345678

data = {} today = os.date('%w') for i = 1, 14 do   data[ i ] = (today - i) % 7 end log(data)

Many thanks,
how can i also get the associated date for the previous days?, taking into account if the range of 14 days is between 2 months,
i have so far the below it assumes feb has 28 days but im not sure it is correct and works properly....
also, is there a way to include the leap year so days_in_month {Feburary} is changing depending if it is 28 or 29 days?

Code:

12345678910111213141516171819202122

days_in_month = {31, 28, 31, 30 ,31, 30,  31, 31, 30, 31, 30, 31} data = {} today = os.date('%w') -- week day number month_day =  tonumber(os.date('%d') )-- date in month for day month_num = tonumber(os.date('%m'))  --%m month (09) [01-12] for i = 1, 60 do   mth_day  = (month_day - i) % days_in_month[month_num]     if mth_day < 1 then     log('exceeded month getting prev month date')     month_num = month_num-1     mth_day = days_in_month[month_num]   end         data[ i ] = { day_num = (today -i) %7, day_in_month = mth_day, month_date = month_num}     end log(data)

[Erwin van der Zwart]

Hi,

You made it way to complicated (: Try this:

Code:

1234567891011

time = os.time() data = {} for i = 1, 365 do   datetimetable = os.date('*t', time)   data[ i ] = { day_num = datetimetable.wday, week_day = os.date('%A', time), day_in_month = datetimetable.day, month_date = datetimetable.month}   time = time - 86400 -- substract 1 day end log(data)

To have a table like in your initial question try this:

Code:

12345678910

time = os.time() data = {} for i = 1, 14 do   data['day ' .. i] = { date =  os.date('%x', time), day = os.date('%A', time)}   time = time - 86400 -- substract 1 day end log(data)

BR,

Erwin

[benanderson_475]

Hi,

You made it way to complicated (: Try this:

Code:

1234567891011

time = os.time() data = {} for i = 1, 365 do   datetimetable = os.date('*t', time)   data[ i ] = { day_num = datetimetable.wday, week_day = os.date('%A', time), day_in_month = datetimetable.day, month_date = datetimetable.month}   time = time - 86400 -- substract 1 day end log(data)

To have a table like in your initial question try this:

Code:

12345678910

time = os.time() data = {} for i = 1, 14 do   data['day ' .. i] = { date =  os.date('%x', time), day = os.date('%A', time)}   time = time - 86400 -- substract 1 day end log(data)

BR,

Erwin

Hi Erwin,

Yes i did make it very complicated..., your way is much better 

Many Thanks

[Dré]

You need to use modulo (%) operator for this:

Code:

12345678

data = {} today = os.date('%w') for i = 1, 14 do   data[ i ] = (today - i) % 7 end log(data)

please can you tell me where i can find that module to import in the LM?

[admin]

It's a built-in arithmetic operator: https://www.lua.org/manual/5.1/manual.html#2.5.1