Skip to main content
sameeru0003
Known Participant
Feb 20, 2025 1:54 PM UTC
Question

Date minus 1 issue in date fields

todate function subtracting date with day minus one day

    10 replies

    stefanhelzle0001
    Brainy
    Feb 20, 2025 2:03 PM UTC

    Welcome :-)

    mikes0011
    Brainy
    Feb 20, 2025 3:06 PM UTC

    The Expression Guru
    Known Participant
    Feb 21, 2025 5:25 AM UTC

    hello

    stefanhelzle0001
    Brainy
    Feb 21, 2025 12:53 PM UTC

    That's a timezone issue. Please share the code.

    https://appian.rocks/2023/02/13/working-with-time-in-appian/

    stefanhelzle0001
    Brainy
    Feb 21, 2025 12:58 PM UTC

    Inspiring
    Feb 21, 2025 1:54 PM UTC

    is the gmt() function something that could help with this as well?

    stefanhelzle0001
    Brainy
    Feb 21, 2025 2:06 PM UTC

    Depends on what you are trying to do ...

    Did my blog post answer some of your questions?

    mikes0011
    Brainy
    Feb 21, 2025 2:42 PM UTC
    todate function subtracting date

    look up converting GMT time into your local timezone and how that affects the displayed date.  it's not really "subtracting", just displaying something you weren't expecting.

    The Expression Guru
    Known Participant
    Feb 21, 2025 2:48 PM UTC

    this may help