- 1. Zoho Deluge: Get the Week Number if Week starts on a Monday
- / Zoho /
- ... overlap at the end/start of the year need to be observed. As per the documentation: dateValue = '29-Dec-2019'; info dateValue.toString("yyyy"); // returns 2019 dateValue = '29-Dec-2019'; info dateValue.toString("YYYY"); ...
- Created on 06 July 2023
- 2. Zoho CRM: Manage a subform using Client Script
- / Zoho /
- ... in this row is start date (retrieved from field "Actual Start Date" on this record) var v_StartDateValue = ZDK.Page.getField('Actual_Start_Date').getValue(); var v_LocalStartDate = new Date(v_StartDateValue); ...
- Created on 09 December 2022
- 3. DataScramble - Randomizing data rows
- / Transact-SQL /
- ... DECLARE @RandChar varchar(1); DECLARE @RandNum int; DECLARE @DateVal date; DECLARE @TimeVal time; DECLARE @DateMatch int; DECLARE @TimeMatch int; ...
- Created on 07 December 2012
- 4. DataJumble - Shuffling characters in a data value
- / Transact-SQL /
- ... DECLARE @RandHour int; DECLARE @RandMinute int; DECLARE @RandSeconds int; DECLARE @RandMSeconds int; DECLARE @DateVal date; DECLARE @TimeVal time; ...
- Created on 01 August 2012
- 5. Formatting a date in an MDX query
- / Transact-SQL /
- ... but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query: CASE DATEPART(DAY, [MyDateValue]) WHEN 1 THEN 'st' ...
- Created on 11 January 2011