Assuming date is required, the following 167 results were found.
-
parameters: Style for Google Maps API v3 - road.arterial - Added parameters: Style for Google Maps API v3 - poi.business - Date Uploaded: Fri, 3rd Apr 2015 Download 1.0 - Released for public use - Date Uploaded: Thu, 2nd Apr 2015
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
"Contact": { "ContactID": "abcdef01-2345-6789-abcd-ef012345678" }, "Reference": "TEST Invoice (DO NOT ACTION) 1", "DueDate": "2021-09-13", "Date": "2021-08-13", "LineItems": [ { "Description": "My expensive product #1", "Quantity": 1, "UnitAmount": 240,...
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle, Dept FROM my_imaginary_table WHERE Contact='Joe' Would become SELECT Date, Reservation,...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
file: [mysqldump] user=my_user password=my_password The one to rule them all: // everything: using external file, suffixing date and compressing: mysqldump --defaults-file=/full-path-to/.my.cnf my_db | gzip > /full-path-to/backups/my_db/backup_`date...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified day...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
Const ICC_HOTKEY_CLASS = $00000040 Const ICC_ANIMATE_CLASS = $00000080 Const ICC_WIN95_CLASSES = $000000FF Const ICC_DATE_CLASSES = $00000100 Const ICC_USEREX_CLASSES = $00000200 Const ICC_COOL_CLASSES = $00000400 Const ICC_INTERNET_CLASSES = $00000800...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Chrome Profiles on your Windows 10 workstation in alphabetical order. Why? This program will be redundant if Google ever update their Chrome browser to list the multiple profiles in alphabetical order like it used to be... but to date they have not. So...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Disclaimerhttps://www.joellipman.com/component/content/article/disclaimer.html?catid=50&Itemid=165
purposes only. The information is provided by Joel Lipman .Com and while we endeavour to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy,...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
meet all of these conditions: a) The work must carry prominent notices stating that you modified it, and giving a relevant date. b) The work must carry prominent notices stating that it is released under this License and any conditions added under...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
personal website). This allows me to continually add data to the api of my own website without needing to redistribute or update this app. {youtube}fQD0xVEYDks{/youtube} Location: For location, type a city name, post code, zip code or any value that is...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
b_Ok = if( v_MyString.matches( v_MyRegEx ), true, false); // yields true Some other validation checks: // validate UK postcode v_MyRegEx =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a Refresh token we will generate an Access token. Pre-amble Quit trying to generate an authtoken v1 (CRM Deprecation Sunset Date: 31st December 2019). Go to the Zoho Developer Console Create a Zoho Client ID Either use self-client for a code or use the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. This message is somewhat out of date but follow the following instructions to preview your app: Open a browser and Ensure you type the preceding “https” rather...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
p_Page, int p_PerPage) { /* Function: fn_eBayQuery_GetActiveProducts() Purpose: Fetches current listings / active products Date Created: 2021-10-13 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
r_ContactRecord.get("First_Name")); m_Data.put("Contact.Last_Name", r_ContactRecord.get("Last_Name")); m_Data.put("Issue.Date", zoho.currentdate.toString("MMMM, dd yyyy")); m_Data.put("Organization.Name",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg. dd/MM/yyyy): You will then be shown a summary of your import: You can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *