Questions tagged [days]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
29 views

I need to skip last five days in a month in SQL - Marketing cloud [closed]

I have a scenario to update a date field(say date 1) based on another date field(say date2) and the date1 field should be updated only if the date2 is between (1/4/2021 to 25/4/2021). ie if it is ...
-1
votes
1answer
43 views

I need SQL Query in marketing cloud to get the second day of next month [closed]

I need SQL Query in marketing cloud to get the second day of next month. For eg, if my current date is 8/4/2021 then my bill should be generated on 2/5/2021. Please guide me on this. I also need to ...
0
votes
1answer
13 views

How do I populate individual dates using addDays() onto a series of child records?

To give you some context, I'm writing a trigger between a parent-child relationship ("Event" - "Day"). When entering number of days into the Event__c object, I would like to ...
2
votes
1answer
442 views

Changing first day of week through Custom Fiscal Years

I've enabled Custom Fiscal Year in a Sandbox, in an attempt to set the first day of week as Saturday (requirement from client). The structure I've chosen is 12 month / year Gregorian. When I preview ...
2
votes
2answers
12k views

How to add days with Date field?

I have one date field called "Billing date" and one Number Field called "Billing Delay". I want to update one Date field "DueDate" which computes "Billing date"+"Billing Delay" for Eg: "Billing ...
2
votes
3answers
2k views

getting dates between two particular dates based on number of days

I have three things getting passed to a method that return List 1.Start date eg 1/1/2018 2.End date eg 1/8/2018 3.Days interval eg 7 days i want to get all the dates from start date to end date ...