... starts at 7, followed by 1 for Monday, 2 for Tuesday, and so on...
How?
The logic behind this would be to take the date of the order, check if the order date is a Sunday, subtract a day, and return ...
... calculate Eastern time (System HQ)
if(!isnull(input.GMT_Date_Time_Start))
{
// subtract 5 hours from GMT as system is based in US/Eastern time
input.System_Date_Time_Start = input.GMT_Date_Time_Start.subHour(5);
...
What?
I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time.
Why?
Just want ...
... in this example is the current date in format yyyy-MM-dd
Due_Date in this example is at the end of the current month: so add 1 month, go to the start of that month, subtract 1 day. .toEndOfMonth() used ...
What?
This is a quick article to demonstrate how to compare two datetime values with the timezone specified.
Why?
A client's ZohoCRM had a different timezone setting than the user a script would ...
Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app
where we need to subtract funds from one account ...
... getdate()))
Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms, seconds * 1000, 0), 114)
Add/Subtract Date DATE_ADD(date,INTERVAL number datepart) DATE_SUB(date,INTERVAL number datepart) ...
... the start of the week date (subtract 1 so this is not inclusive). Crude solution but it works in Excel 2007
Now we want to filter the pivotTable data based on these two values... (I don't like the idea ...
... CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) )
This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.