Expression for the previous 3 months in a sql table

Hi Everyone,

I need an expression to query the previous three months in a sql table in an input tool. I don't need rolling 3 months. So for example, if I run the workflow on 5/20/19 I get the data for 2/1/19 to 4/30/2019 with the correct expression that I am looking for. I need to be able to run on any day of the current month of May and still be able to get data for 2/1/19 to 4/30/2019.

Thanks,

mackedet

Date Time

Accepted answers

Thableaus

@Soxfaninfl

I think there was a missing parenthesis:

WHERE

DATEADD(mm, -3, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0))

<= YOURDATEFIELD

AND DATEADD(DAY, -(DAY(GETDATE())), GETDATE())

>= YOURDATEFIELD

All comments

Thableaus

Hi @Soxfaninfl

If it's a query in SQL Server, I'd use this where clause:

WHERE DATEADD(mm, -3, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) <= YOURDATEFIELD AND DATEADD(DAY, -(DAY(GETDATE())), GETDATE()) >= YOURDATEFIELD

Cheers,

BrandonB

Hi @Soxfaninfl

The following formulas should do the trick. Workflow is also attached.

date formulas.png

date formulas.yxmd

afv2688

Hi @Soxfaninfl ,

For your calculations:

From

todate(tostring(tostring(DateTimeYear([DateTimeNow])) + "-0" + tostring(DateTimeMonth([DateTimeNow])-3)) + "-" + tostring(DateTimeDay([DateTimeNow])))

DateTimeParse(DateTimeAdd([DateTimeNow],-DateTimeDay(DateTimeNow()),"days"),"%Y-%m-%d")

Soxfaninfl

Hi Thableaus,

Thank you for responding. I'm getting the following error. The field is a date/time field. Please advise.

Error Message.jpg

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335