Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming datetime is required, the following 28 results were found.

  1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    if not blank) if(debugString!="") DebugLogEvent(debugString); } } } } private void DebugLogEvent(string DebugString) { DateTime now = DateTime.Now; this.ComponentMetaData.PostLogMessage(DebugLogEventName, this.ComponentMetaData.Name, DebugString, now,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  2. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report finished running? Need to check what finished?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  3. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    v_CustomerCallTime = '2021-11-19 08:12:34'; // // set system/application date time start in CRM format v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") + v_ApplicationTimeOffset; // // set system/application date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  4. Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London") + v_TimeZoneOffset; Note(s): This was done in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *

  5. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    you want to remind the task owner about the task. The possible values are EMAIL, POPUP, EMAILANDPOPUP. TRIGGER=DATE-TIME (DateTime ISO8601): Defines when you want to trigger the reminder. Example: 2020-05-01T12:28:00+05:30. TRIGGER=TIME (hh:mm): 24-hour...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  6. Android: Replace return key with done, go, send...https://www.joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

    sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date // selectable date time // selectable time android:imeOptions normal actionUnspecified...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *

  7. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    + "/" + SUBSTRING(This_Date,7,4)) -- if data source column is of datatype string and european date format: return SQL datetime (TRIM(This_Date) == "") ? (DT_DBTIMESTAMP)"1900-01-01" : (DT_DBTIMESTAMP)( SUBSTRING(This_Date,7,4) + "-" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  8. MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-data-type-reference-table.html

    to "9999-12-31" Date/Time Time 'HH:MM:SS', 'HHMMSS', 'HHMM', 'HH' 3 bytes Range "-838:59:59" to "838:59:59" Date/Time DateTime 'YYYY-MM-DD HH:MM:SS' 8 bytes "0000-01-01 00:00:00" to "9999-12-31 23:59:59" Date/Time TimeStamp 19700101000000 to sometime in...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 21 - 28 of 28