Date / time picker in App Builder?

Me again! I notice that date/time fields in the App Builder are shown in ISO 8601 format (I think) eg: 2024-03-07T00:00:00Z. I was wondering if there were any plans to incorporate a date/time picker into the app so users can change the date time more easily?

In the meantime, I have bodged an ugly and inelegant, but functional temporary solution for anyone else in the same position. I created an iframe with some js:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Date Time Picker</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">
</head>
<body>

<input type="text" id="myDateTimeInput" placeholder="Select Date and Time">
<button onclick="copyToClipboard()">Copy</button>

<script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>

<script>
    flatpickr("#myDateTimeInput", {
        enableTime: true,
        time_24hr: true,
        dateFormat: "Z",
        utc: false,
        onChange: function(selectedDates, dateStr, instance) {
            var modifiedDateStr = dateStr.replace(/\.\d+Z$/, "Z");
            instance.input.value = modifiedDateStr;
        }
    });
    
    function copyToClipboard() {
        var input = document.getElementById('myDateTimeInput');
        input.select();
        document.execCommand('copy');
        alert('Copied');
    }
</script>

</body>
</html>

This adds a date/time picker that converts the time to ISO 8601 (which is how it seems to be stored in BaseRow) and adds a button to copy that result so you can paste it in a text field.

It will be totally useless if you guys do add a date/time picker, but it will get me by for now…

Hi @spook!

I notice that date/time fields in the App Builder are shown in ISO 8601 format

Are you referring to dates shown in the data source filters? I’m struggling to think where else we show dates :laughing:

If so, we follow the same date formatting as in the database builder. The date picker in the filter value will use the same ISO formatting as is configured on the database builder’s field (click Edit Field > Date format).

I was wondering if there were any plans to incorporate a date/time picker into the app so users can change the date time more easily?

Do you mean a date picker element or input element of type=date you can embed into your page? If so, it’s not on the roadmap, but it’s a great idea!

Sorry for the delay in reply. So basically, I have table (tasks) with 2 fields: start date and time and end date and time. I want to be able to create a new entry or edit a current one. Currently when I create a text input field to display the current date/time in an entry, it shows it in ISO format - which is not super user-friendly. If I want to change the date / time or create a new entry, I have to enter it in ISO format - also not super friendly.

Thanks!

Its seems that in the app builder it’s different. In the table collum its 21/4/2024 and in the app it shows like 2024-04-21.