Date field also shows time

Forms Public Forms
1

How does one remove time from a date field, or get the accurate time?
Currently it's always showing the same time 12:00.

image

2

@Viorel
Did you try in list settings in date field to select date only?

image
image1120×757 60.6 KB

3

Hi @ixxxl, thanks for replying!

Where do I find the list settings, I've looked everywhere.

(I'm new to Plumsail.)

4

@Viorel
list settings of SharePoint List.

image
image782×741 70 KB

5

I didn't create a SharePoint form, just a regular one.

6

Dear @Viorel,
There are two different fields, you need the Date field, not the Date Time field:
image

7

Yep, that's exactly what I'm using. I've even removed and re-added it, yet it will still show the selected date and 12:00 on the Word extract.
(I've set it to save the word doc onto my OneDrive as a test.)

8

Dear @Viorel,
I see what you mean - every date comes with time, that's just how dates work in browser. There are many ways to work around it - you can either format date in the flow/process whichever you use, or you can use JavaScript on the form to copy value as text to another field.

9

I use Processes. Would be able to tell me how to format the date in Processes.
If it isn't too much work for you.
Thank you!

10

Dear @Viorel,
Here, check out this page for more information - Value properties in DOCX, XLSX and PPTX templates — Plumsail Documents

11

Perfect!!!

Instead of {{Date}}

I used: {{Date.Day}}/{{Date.Month}}/{{Date.Year}}

Which results with: day/month/year as below

image

Thank you very much @Nikita_Kurguzov !
It's highly appreciated!

12

To take it one step further:
I just found out we need a date range (but not always) instead of one date.
Sometimes it's just one date, other times it's date one to date two.
Example:
Sometimes it will be: 27/10/2022
Other times: 25/10/2022 - 27/10/2022

I'm thinking to just replace the date field with a text field, but just wondering whether it's possible to have a date range?

13

Dear @Viorel,
You can have two Date fields, and configure them in a way that the second field has to be later than the first day with JavaScript, here's an example:

fd.rendered(function() {
    //add validation to the start date
    fd.field('StartDate').addValidator({
        name: 'Start Date validation',
        error: 'Enter valid date',
        validate: function(value) {
            var startDate = value;
            var endDate = fd.field('EndDate').value;
            if (endDate && startDate >= endDate) {
                this.error = 'The start date must be before the ' + endDate;
                return false;
            }
            return true;
        }
    });
    //add validation to the end date
    fd.field('EndDate').addValidator({
        name: 'End Date validation',
        error: 'Enter valid date',
        validate: function(value) {
            var startDate = fd.field('StartDate').value;
            var endDate = value;
            if (startDate && startDate >= endDate) {
                this.error = 'The end date must be after the ' + startDate;
                return false;
            }
            return true;
        }
    });
});

Now, to make it work, you need to give your fields Names: StartDate and EndDate:
image

Then, copy the code above inside JavaScript editor (outside of the commented out part, you can just replace all code in there):
image

1 Like
14

@Nikita_Kurguzov WOW! That worked like a charm!!!

Thank you, very, very much, sir!

1 Like