Search - Joel Lipman .Com

1. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the day counting ...; Created on 06 July 2023
2. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Additional The reverse (date string to unix seconds) can be done using either of the following: v_MyDate = "2020-04-01 12:34:56"; v_UnixSeconds = v_MyDate.toTime().toLong(); info v_UnixSeconds; // ...; Created on 04 May 2020
3. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssZ"); // ...; Created on 06 February 2020
4. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about ...; Created on 23 April 2013
5. MySQL day of week ending on Friday: / MySQL /; ... AS WeDate -- yields -- 2012-04-29 -- this Sunday -- 2012-04-29 -- this Sunday -- 2012-04-29 -- this Sunday Other Searches These didn't get me very far until I decided to write this article: DAYOFWEEK(myDate, ...; Created on 26 April 2012
6. Formatting a date in an MDX query: / Transact-SQL /; ... as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy") ... 6/15/09 =Format(Fields!myDateTime.Value, ...; Created on 11 January 2011