Forum Discussion

doug_fossler's avatar
doug_fossler
New Contributor
8 years ago

Javascript example for date/time manipulation in script snap?

I am attempting to write javascript for a script snap to manipulate dates, times, and date/times. I am having issues getting a date field plus a separate time field parsed as a DateTime and further ...
doug_fossler's avatar
doug_fossler
New Contributor
8 years ago

An easy example (i.e. only three docs).

[
    {
        "groupBy": {
            "resourceId": "999000641",
            "EventDate": "07/24/2017"
        },
        "group": [
            {
                "resourceId": "999000641",
                "punchInDate": "07/24/2017",
                "EventDate": "07/24/2017",
                "break": null,
                "costCenter": "54770",
                "timeType": "1",
                "punchInTime": "06:53",
                "resourceLastName": "brown",
                "$rowCountPernull": 1,
                "WorkedHours": "4",
                "punchOutTime": "10:53",
                "siteId": "500",
                "punchOutDate": "07/24/2017",
                "resourceFirstName": "Test",
                "yalePayCode": "1",
                "optPayTypeId": 1
            },
            {
                "resourceId": "999000641",
                "punchInDate": "07/24/2017",
                "EventDate": "07/24/2017",
                "break": null,
                "costCenter": "54620",
                "timeType": "1",
                "punchInTime": "10:53",
                "resourceLastName": "brown",
                "$rowCountPernull": 2,
                "WorkedHours": "3.5",
                "punchOutTime": "14:23",
                "siteId": "500",
                "punchOutDate": "07/24/2017",
                "resourceFirstName": "Test",
                "yalePayCode": "1",
                "optPayTypeId": 1
            },
            {
                "resourceId": "999000641",
                "punchInDate": "07/24/2017",
                "EventDate": "07/24/2017",
                "break": null,
                "costCenter": "64990",
                "timeType": "1",
                "punchInTime": "14:23",
                "resourceLastName": "brown",
                "$rowCountPernull": 3,
                "WorkedHours": "5.25",
                "punchOutTime": "19:38",
                "siteId": "500",
                "punchOutDate": "07/24/2017",
                "resourceFirstName": "Test",
                "yalePayCode": "1",
                "optPayTypeId": 1
            }
        ]
    }
]```