Wednesday, February 27, 2019

Add Days to Date Type Field in Saved Searches using Formula

There is currently no built in function to add days for fields in saved searches (only ADD_MONTHS is available). To add days though, user can choose the Formula (date) type field in the Field dropdown and append "+" then the number of days to add.

Example:

To add 3 days to the transaction date use the formula:

{trandate}+2

on

2 comments:

  1. WillodAugust 13, 2020 at 7:34 AM

    Nice, thanks.
    is there a way to subtract 7 hours? I would like this to show different time zones

    ReplyDelete
  2. WillodAugust 13, 2020 at 7:38 AM

    Actually figured it out, can use {trandate}+0.5 for 12 hours.
    Didn't work at first but now OK.

    ReplyDelete

Subscribe to: Post Comments (Atom)