AddHours help | Community
Skip to main content
H
HowardWi1
Level 3
November 4, 2020
Question

AddHours help

  • November 4, 2020
  • 1 reply
  • 498 views

Can't get this date to subtract 14 days. Have added and removed extra colons, tried reformatting the date, nothing works. It's probably something simple or right under my nose.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    D
    darin_patterson
    Level 4
    November 4, 2020

    Hi Howard, I can't really tell from your screenshot. But here is how I would troubleshoot this:

    Confirm what is coming out of that particular field without any manipulation by removing the "addDays" completely.

    • based upon what value is, determine whether it is actually a date. If it is really a date ...it would show in a UTC format. You could also hover over the column in the mapper to determine the data type (text or date).

    I suspect the data is literally blank or not actually a date. If it is not actually a date, then you'll need to use parseDate to get it to an actual date. Depending on the format you see when you look at the date, itself.

    Terms & ConditionsAccessibility statement

    Loading footer...