Forum Discussion

ErichSiemon's avatar
ErichSiemon
Qrew Member
2 years ago

Date value changes when copied to new table with pipeline.

I am updating an app with a [Fines] table that has 10 pairs of Pmt-Dt-* and Pmt-Amt-* fields. The date fields are Date (not Datetime). 1) I created a new [Payments] with Fine-ID, Pmt-Dt, and Pmt-Amt...
Pipelines
DougHenning1's avatar
DougHenning1
Quickbase Staff
2 years ago

If you add the time to the date then it should not roll back to the previous day:

{{ (a.payment_date|date_ymd) ~ "T12:00" }}

Creates a string like "2018-08-08T12:00"

  • ErichSiemon's avatar
    ErichSiemon
    Qrew Member
    2 years ago

    This did not work for me, but I have been unable what my mistake is.

    My source tbl/fld is 01-01-2023.

    My original pipeline logic displays 12-31-2022 07:00PM (EST) in the destination tbl/fld.

    My revised logic displays 01-01-2023 07:00AM (EST) in the destination tbl/fld.