Jump to content

Compare Two Dates

Recommended Posts



I have a table holding two fields with dates I try to compare in java script.


The first date is generated by caspio timestamp, and called "date_submitted", formatted like"05/15/2014 23:43:58" in the table.

The second date,"Date_event_start", is a date submitted from a Caspio calendar, formatted like "05/30/2014" in the table.


When i insert both dates in a HMTL block within Caspio they retur quite different.


"date_submitted" returns: "05/15/2014 11:43:58 PM"


"Date_event_start" returns:  "30.05.2014"


Why does Caspio default output different date formats???



I want to compare the dates with a simple script like:



<a id="visi[@field:ID_delegate]">
var isi = document.getElementById("visi[@field:ID_delegate]");
if('[@field:date_submitted]' >= '[@field:Date_event_start]'){
isi.parentNode.parentNode.style.backgroundColor = '#FFB0AD';
isi.parentNode.parentNode.style.backgroundColor = '#ADD8E6';
How can i make the different date fields comparable???
--- Frode ---
Link to comment
Share on other sites

Hi Frode,


Is it a Result page of a Report DataPage?


On Configure Results Page Fields step, select your date.

In the Field options, there is the Formatting field.

I think, you can click the "Edit" button and select the same format for both dates.


On my DataPages i selected "Localization" for both fields and they work.

Link to comment
Share on other sites

Hi Jan.


Yes, it is a Result page of a report Datapage.


The formatting field solved it for me.

i had to include all date fields in the result page to make sure they where equally custom formatted.

To bad there is on option to hide fields you don`t want, but still need to format.


Thank you.



--- Frode ---

Link to comment
Share on other sites

  • 9 years later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...