Participant

Question

Need help with date scripts from 3 fields

Forum|Forum|4 years ago
March 27, 2022
1 reply
667 views

Hi community, I have the following issue.

I have a form where there is 3 fields for the date (expressed as week ending)

DD

MM

YY

then I have 5 other fields where I need the date to be displayed as monday to friday dates.

I used to use this script where the original date was as one field and it worked nicely (example is for the monday date hence the "-4")

var date= util.scand("dd/mm/yyyy", this.getField("Week ending").value);
date.setDate(date.getDate()-4)
event.value=util.printd("dd/mm/yyyy",date)

How can i modify this to work with the 3 Fields?

Partial screen shot attached.

thanks

This topic has been closed for replies.

try67

Community Expert

The screenshot is from the previous version, so we don't know what the actual field names are, but assuming they are "Week ending1" to "Week ending3", you can use this:

var date = util.scand("dd/mm/yyyy", this.getField("Week ending1").value + "/" + this.getField("Week ending2").value + "/" + this.getField("Week ending3").value);
if (date!=null) {
	date.setDate(date.getDate()-4)
	event.value=util.printd("dd/mm/yyyy",date)
} else event.value = "";

D

David23770136wgmuAuthor

Participant

Thanks for your ideas...

So this didn't really work as intended (some fields were showing blanks)

I did use some of the information here and combined it with what I was using before and it worked perfectly.

the 3 original fields as mentioned in original post were:

"DD" with value of "01"

"MM" with value of "04"

"YY" with value of "22"

all 3 of these fields are formated as "NONE" Iv'e since renamed these fields to "DAY, MONTH, YEAR"

from these 3 fields they format 5 other fields formated as "DATE" (dd/mm/yyyy) these are :

"monday" this self populates as "28/03/2022"

"Tuesday" this self populates as "29/03/2022"

"Wednesday" this self populates as "30/03/2022"

"Thursday" this self populates as "31/03/2022"

"Friday" this self populates as "01/04/2022"

here is the calculation I used in the end:

var date= util.scand("dd/mm/yyyy", this.getField("Day").value + "/" + this.getField("Month").value +"/20" + this.getField("Year").value);
date.setDate(date.getDate()-4)
event.value=util.printd("dd/mm/yyyy",date)

this example was for the monday and only change the -4 to a -3, -2, -1, or -0 for the rest of the days.

Hope this can help someone else as i've used this forum a few times for some great info.

I might try attach a small portion of the file here in the coming days for perusal if wanted one I finish my project.

try67

Community Expert

You will get an error if you clear one of those fields, though, as "28/03/" is not a valid date string, for example.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded