Skip to main content
sameeru0003
sameeru0003
Known Participant
February 20, 2025
Question

Date minus 1 issue in date fields

todate function subtracting date with day minus one day

    10 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 20, 2025

    Welcome :-)

    mikes0011
    mikes0011
    Brainy
    February 20, 2025

    The Expression Guru
    lalithyak964917
    Known Participant
    February 21, 2025

    hello

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 21, 2025

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

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

      stefanhelzle0001
      stefanhelzle0001
      Brainy
      February 21, 2025

        zakarym8213
        Inspiring
        February 21, 2025

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

        stefanhelzle0001
        stefanhelzle0001
        Brainy
        February 21, 2025

        Depends on what you are trying to do ...

        Did my blog post answer some of your questions?

        mikes0011
        mikes0011
        Brainy
        February 21, 2025
        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
        lalithyak964917
        Known Participant
        February 21, 2025

        this may help 

        Terms & ConditionsAccessibility statement