Skip to Content

I wish to pull data from ONLY the previous day data

Hi All,

i want to restrict with calendarday with current date-1

i tried with below formulas,

{datefield} = CurrentDate -1

{datefield} = dateadd("d",-1,currentdate)

Could you let us know what made you to resolve issue.

Thanks in Advance.

Priyanka

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 09, 2016 at 10:19 AM

    Hi Priyanka,

    If this is a datetime field, try:

    Date({Date field}) = Currentdate - 1

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2016 at 05:22 AM

    Thanks For Reply.it Worked.

    Add comment
    10|10000 characters needed characters exceeded