Assuming yyyy is required, the following 26 results were found.
-
A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. If we are getting a date from a CSV or other external source as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
SSRS / MDX Date Querieshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html
The following examples assume today's date is Wednesday 03 August 2011 @ 11:46: This Week: -- Start Date (US format - mm/dd/yyyy) =DateAdd("d", -(WeekDay(Today(),2))+1, Today()) // yields: 8/1/2011 -- End Date (US format - mm/dd/yyyy) =DateAdd("d", -1,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
calendar.StartDate) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, calendar.StartDate), 1, 3) + '-' + CAST(DATEPART(yyyy, calendar.StartDate) AS VARCHAR(4)) AS Monday, CAST(DATEPART(dd, DATEADD(d, 1, calendar.StartDate)) AS VARCHAR(2)) + '-' +...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00 v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-03-08 02:00:00"); // // Ends First Sunday in November at 2:00 v_LastMonthDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09 =Format(Fields!myDateTime.Value, "M/d/yyyy h:mmtt")... 6/15/2009 2:45PM =Format(Fields!myDateTime.Value, "MM/dd/yy HH:mm")... 06/15/09 14:45...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Date/Time: "); v_ResultInformation = v_ResultInformation.concat("" + v_CustomersRequestedTime.toString("EEEE, MMMM dd, yyyy @ h:mma") + " " + v_CustomerTimeZoneName + ""); v_ResultInformation = v_ResultInformation.concat("Agent's Appointment...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the attachment. Created Time: This is the created time of your file in the format that your CRM system is using (eg. "dd/MM/yyyy HH:mm:ss") Modified Time: This is the modified time of your file in the format that your CRM system is using (eg....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
what worked for me... Set the default values for your from and to date respectively: -- From Date (european format - dd/mm/yyyy) =CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now()))) -- To Date (european format - dd/mm/yyyy)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two dates one which was imported as a string (DT_WSTR) and another as a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy hh:mm a"); // // future proofs v_ExchangeRate = if(v_ExchangeRate == 0,1,v_ExchangeRate); // // transforms if(r_Result.get("Valid_Till") !=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
p_original_range_2; END IF; -- Determined submitted value as 'DATE'; v_rand_param1 := TO_CHAR(TO_DATE(v_rand_param1,'dd/mm/yyyy hh24:mi:ss'),'J'); -- eg. from 01/01/1901 (Julian Days) v_rand_param2 := TO_CHAR(TO_DATE(v_rand_param2,'dd/mm/yyyy...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
= v_NextRenewalDate.toString("EEEE, d") + v_EnglishOrdinal + " of " + v_NextRenewalDate.toString("MMMM, yyyy"); info v_ContractDateFormatted; // yields Tuesday, 6th of November, 2018 Method #5: if a list contains: v_NextRenewalDate = '2018-11-06';...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= Document[ID == r_CheckIfDocumentAlreadyExists.ID]; v_DateAdded = r_NewDocumentRecord.Added_Time.toString("E, d MMM yyyy HH:mm"); } else { r_Document = insert into Document [ Added_User=zoho.loginuser Document_Name=r_Attachment.get("File_Name")...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= Order[ID == 123456890123456890]; if(c_Order.Order_Date != null) { v_ThisDate = c_Order.Order_Date.toString("EEEE, dd-MMM-yyyy u w"); v_ThisWeek =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
how many days there are in a month so this is a crude solution ; This checks if this year is a leap year Check1:=Mod(A_YYYY,4) Check2:=Mod(A_YYYY,100) Check3:=Mod(A_YYYY,400) if (Check1=0) AND (((Check2=0)and(Check3=0)) OR (Check20))...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
} The following function is to convert a given SQL date or a European date formatted value: FormatDate(val) { ; SQL format (yyyy-mm-dd HH:mm:ss) IfInString, val, - { StringReplace, val, val, -,,All StringReplace, val, val, :,,All StringReplace, val,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Month NameMONTHNAME(now())DATENAME(mm, getdate()) Month NumberMONTH(now())DATEPART(mm, getdate()) European Date (dd/mm/yyyy)DATE_FORMAT(now(), '%d/%m/%Y')CONVERT(varchar, getdate(), 103) Time to SecondsTIME_TO_SEC(now())(DATEPART(hour, getdate()) *...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
; MESSAGES Message0:="All's well at " A_Hour ":" A_Min " on " A_DDDD ", " A_DD " " A_MMMM " " A_YYYY "`n`nAnd it's time for that gentle reminder..." Message1:="In total...`nYou have " ThisManyWeeksMessage " left at BU.`n`nIn more detail:`n • "...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
conversions and strings but what if the value is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of DATE_OF_BIRTH is blank or null yields // -- errors How?...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *