adding a day to a date

What is the way to add a day to a date?

For example, when I do: datetime(year(today()), month(today()), day(today()) + 1, 13), it doesn't work for the case when today() = last day of the month. For example, yesterday was the last day of the month (the 31st) and we had an issue because 31 + 1 is 32 and that day doesn't exist. What is the way to add a day so that the system figures out by itself that August 31st + 1 is September 1st and not August 32nd?

OriginalPostID-232448

  Discussion posts and replies are publicly visible

Parents Reply
  • I have checked this. Its coming out without filtering even coming out with todatestamp(today()) also. I have saved this in DB as timestamp only. Its not working with (>,today()+1,etc) where ever i am trying to fetch data greater then current date.

     

    =a!queryEntity(
    entity: cons!TEST,
    query: a!query(
    logicalExpression: a!queryLogicalExpression(
    operator: "AND",
    filters: {
    if(
    ri!dateFlag = "date",
    a!queryFilter(
    field: "start",
    operator: "=",
    value: todatetime(
    today()
    )
    ),
    a!queryFilter(
    field: "start",
    operator: ">",
    value: todatetime(today()+5*day())
    )
    )
    }
    ),
    pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: - 1
    )
    )
    ).data

Children