What?
An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the ...
Why?
I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count ...
... Date (european format - dd/mm/yyyy)
=CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now())))
-- To Date (european format - dd/mm/yyyy)
=dateadd("d",-1, CDate("01/" + cstr(month(today.now())+1) ...
... about 4 months until I can confirm this works.
Why?
I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, ...
... writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a solution.
How?
Disclaimer ...
... Transfer Protocol on a Port number of your choosing:
Set for new imports to append, replace, or check if exists then insert/replace:
Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly:
...
... Start Starts Second Sunday in March at 2:00
DST End Ends First Sunday in November at 2:00
//
// Starts Second Sunday in March at 2:00
v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") ...
... every month"...
How?
Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...
... going to use a range of 1 month before and 1 month after the requested date (so this works as long as no one books longer than a month in one go - increase the submonth/addmonth parameter if an employe ...
... was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my ...
... month, takes the invoices for the month before, and duplicates each one for the new month.
How?
First you have to get all the applicable fields from the settings API. In API v2, you have to do ...
What?
This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month.
Why?
Fine if you are determining the quarter by the month and your Fiscal ...
... yields I am Joe
Not a regular expression but something I use to pad months and dates in a date format:
v_MyString = 2; // February
v_FormattedString = leftpad(toString(v_MyString), 2).replaceAll(" ...
What?
Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds.
Why?
Here are some examples of what ...
... vendor, etc.
Why?
This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time ...
... built-in functions of Zoho deluge.
Method #1:
Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month):
// get the date (eg. 1, ...
... Points of Interest (POI). Considering
I spent a good month styling Google Maps for Android OS on a mobile app,
having access to the Google Map API v3 in JavaScript is a doddle... And
incredible ...
Joe did a really superb job for me on this. My website crashed and I had no idea how to fix it. My hosting service were no help at all. Worse, I hadn't backed up my website for 18 months so even if Joe ...
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.