Wayne (and anyone else who needs it) … here’s what I ended up with (it works!!)
- Show a date from my database
- Calculate a date X days after the original start date, and show that on the page as well
- Format both dates to read as Month Date, Year (“April 20, 2018”)
Note: you can format the date any way you need by making a few changes to the line:
// formats date to Month Date, Year
var expDate = longMonth + " " + day + ", " + year;
Here’s the first part of the CODE →
(This goes into data.js in the backend)
export function Members_afterQuery(item) {
item.expDate = setMemberExpDate(item._createdDate);
return item;
function setMemberExpDate(_createdDate) {
var originalDate = new Date(_createdDate);
var date = new Date(originalDate);
// set expiration 1 year
date.setDate(date.getDate() + 364);
const monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
const day = date.getDate().toString();
const longMonth = monthNames[date.getMonth()];
const year = date.getFullYear().toString();
var expDate = longMonth + " " + day + ", " + year;
return expDate.toString();
}
}
THEN
(This goes into the page code – in this case, I’m using static text fields on a dynamic page)
$w.onReady(function () {
$w(“#membersDataset”).onReady(() => {
populateCalculatedFields();
reformatJoinDate();
});
});
function populateCalculatedFields() {
const currentItem = $w(“#membersDataset”).getCurrentItem();
$w(“#expDate”).text = currentItem.expDate;
}
function reformatJoinDate() {
let originalDate = $w(“#joinDate”).text;
let date = new Date(originalDate);
const monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
let day = date.getDate();
let longMonth = monthNames[date.getMonth()];
let year = date.getFullYear();
$w("#joinDate").text = longMonth + " " + day + ", " + year;
}
A few notes…
I’m sure the function reformatJoinDate can be simplified, as this is mostly a copy of the code in data.js – but I kept getting stuck there, so this works
Also, if you are doing this in a repeater you’ll need to add a line after the onReady
$w(" #repeater1 ").forEachItem( ($w) => {
So Wayne, you’ll need to make a few changes to make this work for you:
- My expDate becomes your quoteDate
- Change the “Members” in Members_afterQuery(item) to the name of your database
- If your original date doesn’t come from the _createdDate, change that as well
- You’ll need to make changes to the page code as well to connect to your page elements
Good luck, let me know how it goes!
