SQL Qurey

Question

I have two fields Last Pay Date and Payment Due Date so if someone missed there Payment due date by 5 days I want those records.

Now the issue is i dont have extra field to identify the days the missed by.

want to use Last Pay date and if Last Pay Date is not Payment Due date then calculate the days ?

Thanks,

Malik

#SQL @Mateusz Dąbrowski

Tim Ziter · Accepted Answer

Per  @Mateusz Dąbrowski https://trailblazers.salesforce.com/profileView?u=0053A00000FTFC7QAP 's amazing SQL resources try experimenting with DateDiff in your Where clause.  https://mateuszdabrowski.pl/docs/sql/sfmc-sql-date-functions/

Lakshmi Pavani S · Answer

@Malik Amodi https://trailblazers.salesforce.com/profileView?u=0053A00000D7Z3uQAF ,  As  @Tim Ziter https://trailblazers.salesforce.com/profileView?u=0053A00000FMnVaQAL  was mentioning, please check the sql resources available.   I hope you can use a case statement to display this difference in the SQL and you can export the retrieved rows to a data extension.   Thanks, Lakshmi Pavani

SQL Qurey

* Marketing Cloud Engagement *

更多帮助