timestamp

How would I build a 24 hour timer?
What I am Wanting to Accomplish You know how a lot of apps reward you for logging in and collecting some type of bonus that becomes available every 24 hours? I'm trying to figure out how to build that in Xano/WeWeb. I'm wanting to gamify my site a little bit that will reward users w/ points for certain actions that then…
Getting the error; Please use a numerically indexed array.
I've created a 'for each' loop to change the format of my timestamp. However, when I run it, I receive the error message 'Please use a numerically indexed array.' Does anyone know what I'm doing wrong?
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function?
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function? Below is a recording of my current setup that works in my 'Query All Records' function. However, in my 'Get Records' function, I'm encountering the following error: 'Please use a numerically indexed array.
Sum a duration field in the correct format
I have a database where I am keeping track of incoming calls. I have a field where I keep track of the duration of the call in this format minutes:seconds. Currently I have this formatted in a text field. I need to sum up these duration values and return them in this format hours:minutes:seconds. Does anyone know how I can…
Add "Current/Now" Button to Date
Hello, please just add finally something to "add current time" so you don't have to manually click every single date/hour/minutes/seconds…. This is so time consuming - this problem is so simple to solve and yet there is no option for that)… I'm getting "permisson problem" uploading image here (don't know why)
1.53.2 (Jun 22, 2023)
📤 New Function - Post Process Post Process allows you to add additional logic to your function stack that will execute after the API returns its designated response. This will allow you to reduce the time it takes for your APIs to respond if there is additional logic that you need to perform that is not required to…
Formatting UNIX timestamp in query Addon
HI all, I need some help to solve an issue. I have a query all records where I run a for each loop to format a timestamp in human readable format. However, the query has an Addon that brings individual time stamps called as trackers. I need also to format the timestamp from the Addon and haven't found a solution so far.…
Can't add Timestamp greater than today
Hi guys, I can't add a timestamp record greater than today to a column, it keeps converting it to today's timestamp or less. What can I do?
format_timestamp applied at wrong level
I'm trying to format a timestamp using the format_timestamp filter (#1) that is on the output of an add-on and the add-on could return multiple values. Instead of the date at #2 being updated, the function is adding a new date #3. What do I have to change have the date at #2 updated? Thanks!
Updating Start and End Dates
Context: Start Date - Timestamp End date - Timestamp I have groups which run weekly. I need the start and end date to update once the current time has passed the end date. Once it has passed, I need to add seven days to the timestamp. How am I able to automate this?
Confusing Display of Dates in Database View
Hi there, In my day to day operations for my app, it is critical that my data is saved in UTC, which it is currently doing. However while doing a query based on dates recently, I was missing some data, and while investigating the dates in my Xano database I got very confused thinking my dates where incorrectly being stored…
it is possible to create a reference point in time using Xano? (chat basic notifications)
Hello, I have developed a chat application and I am trying to implement a feature where notifications are sent when a message is received by the intended recipient. To achieve this, I have two databases - one contains chatroom IDs and the IDs of the two users involved, while the other contains the messages, including the…
How do I create a program that can schedule recurring dates
Hi all, I'm trying to build an application where the admin is able to schedule a program to recur based on the days of the week and the time. For instance, every Monday, Tuesday, and Thursday at 7 am, there is a breakfast offer. Could I get some help in building this? Such as how the database and API should be designed?…
How to execute a task that is running every minute but only at a specified time?
I have a task that is running every minute and have a slurry of functions to run but only at certain times. Essentially I want to write a condition that if current time is 1am for instance, execute my function once (it should only happen when that time is hit, every other minute that elapses after should not continue to…
How to format "NOW" to UTC when adding a record
The image is pretty explanatory, im trying to format "NOW" to human readable format. when i debug its showing a different format What did i miss ?
How to get number of Months since unix epoch
Hey guys, Is there a filter option to get the number of months from the unix epoch? I'm doing a query all records and looking to see if the user already has a record in the table for the current month, so looking to get the number of months since the unix epoch to compare. How would I go about this? Thanks
INPUT ERROR INVALID TIMESTAMP
When someone fills out the input boxes on a patient registration it is supposed to transfer to Xano. I am trying to set up a custom action with Xano API (create and POST) that will add the form input onto my Xano table. I keep getting “INVALID TIMESTAMP FORMAT” See pics below. Please help!
Adding dates through Adalo
I am trying to allow user to input their date of birth (front-end is Adalo). How do I format the field on Xano and Adalo? I keep getting “Invalid format”
Transforming ISO String to Timestamp
Hi, I have a problem and i don't know how to solve it .After an airtable import I have a computed string field containing a string in ISO format ( because it was a computed field in Airtable ): 2023-01-02T16:03:44.818Z (by the way there is a bug in Airtable import when you have a DATE field with the option "include time"…
Timezone Not Local
Hi, I have a function with 2 inputs: { "date_input": "now", "timezone_input": "America/New_York" } I'm trying to get the date for users in New York. However, when I run my function it keeps giving me the date for UTC rather than the local date. Not sure what i'm missing, I included screenshots below, it's Nov 21st New York…
What is the formula to convert timestamp to days ago?
I have the creation date in timestamp and I would like to change it to something like "created 2 days ago" how should I do it?

timestamp

Discussion List