[Custom function] Get the current date and time by the timezone

Here is a custom function to get the current date and time by the timezone.   Source code   Parameters tz … timezone name (ex: GMT, UTC, ECT, JST…)   Responses date and time (string format)   How to know the codes of time zones? Please refer the following post; The list of time zones

The list of time zones

Name Description Relative to GMT GMT Greenwich Mean Time GMT+0:00 UTC Universal Coordinated Time GMT+0:00 ECT European Central Time GMT+1:00 EET Eastern European Time GMT+2:00 ART (Arabic) Egypt Standard Time GMT+2:00 EAT Eastern African Time GMT+3:00 MET Middle East Time GMT+3:30 NET Near East Time GMT+4:00 PLT Pakistan Lahore Time GMT+5:00 IST India Standard Time … Read more The list of time zones

Date format

Here is an easy tip about the date format.   Source code   Format   Parameters (1) date … Date value. (2) timezone … Timezone. This parameter requires like “GMT+2:00”. (3) format … Date format.   Responses string

Today’s date and time

Here is an easy tip how to get the current date & time.   Source code   Format new Date()   Parameters None   Responses string   How to change the time zone? The value depends the time zone setting of the Project properties. If you want to config it, please access “File” -> “Project … Read more Today’s date and time

Backward match

Here is an easy tip about the backward match.   Source code   Steps to check the backward match Google Apps Script doesn’t supply the backward match function. Thus you have to code to do achieve it. The followings are steps to check the backward match; (1) Get the length of str1. (2) Get the … Read more Backward match

Forward match

Here is an easy tip about the forward match.   Source code   Format   Returns The value2 is found within value1 then it returns the start position number. On the other hand, if it is not found, it returns -1. → If it returns 0, it means the value2 is included within the beginning … Read more Forward match

Particle match

Here is an easy tip about the particle match.   Source code   Format   Returns The value2 is found within value1 then it returns the start position number. On the other hand, if it is not found, it returns -1.   What is the difference between “===” and “==”? The triple-equal “===” is preferred … Read more Particle match

Exact match

Here is an easy tip about the exact match.   Source code   Format   How to check not the exact match? Here is the sample.   What is the difference between “===” and “==”? The triple-equal “===” is preferred to be used instead of the double-equal “==”. I’ve posted about this in the following … Read more Exact match

What’s the difference between Double-equals and Triple-equals?

In a comparison using the double-equals operator, the result will return true if the two things being compared are equal. But there’s one important catch: If the comparison being made is between two different “types” of values, type coercion will occur. Each JavaScript value belongs to a specific “type”. These types are: Numbers, strings, Booleans, … Read more What’s the difference between Double-equals and Triple-equals?