Assuming format is required, the following 101 results were found.
-
I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
SSRS 2008 R2. 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)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString, %Format% return Formattedtime } The following function...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06" = 34 hours and 6 minutes). Error(s) Input Parameter Missing (6831): Can happen when there are either...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
a date (so 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
-
Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
working in 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
// get the value we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation symbols) ValueToConvert =...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Query #1: Works from command-line but may generate "Empty Query 1065" SELECT calendar.WeekNumber AS AcademicWeek, DATE_FORMAT(calendar.StartDate, '\%e-\%b-\%y') AS Mon, DATE_FORMAT(DATE_ADD(calendar.StartDate, INTERVAL 1 DAY), '\%e-\%b-\%y') AS Tue,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
fields" (in this case "Edit CAP exchange fields") Under "Exchange Fields", tick which boxes to output Under "Export format", specify any code lookups (eg. for CAP_STAC, we want the code and the lookup value/name and then something to display if the...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
not found in /home/thirdpartyapi/public_html/thirdpartyapi_controlpanel/user/addons/thirdpartyapi_webservice/Service/Format.php:86 Stack trace: #0...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3){cursor:pointer;} Then I formatted the color of the text and set the general text font to be applied overall / included tweak to width so "Wednesday" will not wrap:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots below are made up. the Attachments.csv A data...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
object in the column. Export the report to Excel and on extra blank columns will appear in the worksheet. NOTE: Fields formatted so they are much wider than the actual size of the data can cause blank columns. Make sure the field width is just wide...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
or 26640 seconds). How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ----------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails = zoho.crm.getRecordById("Calls",123456789012345678); info r_CallDetails; // // system/application is set to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *