Payment

[Alaena_VanderMo]

Hi Everyone! Please read and let me know what your turn around time and fee would be here…I need some help with the following:

If created date is in the last two weeks, and between the 1st and the 15th, payment is due on the 15th.

If created date is in the last two weeks and between the 16th and last day of month, payment is due on the last day of the month.

If payment is due on the 15th, payment will be issued on the 19th
If payment is due on the last day of the month, payment will be issued on the 4th.

So fields are: submitted (created at date), Due Date (formula/date), Issue Date

Submitted: 4/3/2018
Due: 4/15/2018
Issue: 4/19/2018

Submitted: 5/22/2018
Due: 5/31/2018
Issue: 6/4/2018

Submitted: 2/16/2018
Due: 2/28/2018
Issue: 3/4/2018

[Jeremy_Oglesby]

Answered you here:

Need some help with conditional date formula (finding last day of month)! Ask the community

What do you want returned if the created date is greater than the last two weeks? This will work for your “Due Date” field, assuming a field named “Submitted”: IF(DATETIME_DIFF(TODAY(),Submitted,'days')<=14,IF(DATETIME_FORMAT(Submitted,'D')<=15,DATEADD(Submitted,15-DATETIME_FORMAT(Submitted,'D'),'day'),IF(DATETIME_FORMAT(Submitted,'D')>15,DATEADD(DATEADD(DATETIME_PARSE(SUBSTITUTE(DATETIME_FORMAT(Submitted,'L'),DATETIME_FORMAT(Submitted,'D'),'1',1),'M/D/YYYY'),1,'month'),-1,'day'),BLANK()))) H…

For future reference, the #work-offered section is usually for posting paid work opportunities. If you’re just looking for help with some formulas, you can just post to #support and it will get addressed there.

…although, I’m happy to take your money for the support :stuck_out_tongue_winking_eye: