Situation
The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just ...
My setup
Windows XP SP3
MS SQL Server Management Studio 2008
SQL Server 2008 R2
Regional Setting: London BST (British Summer Time)
Tuesday the 11th of October 2011 at 06:00am:
CONVERT(CHAR(19), ...
Thought 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 ...
...
Conversion failed when converting date and/or time from character string.
Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query.
Once ...
... following:
SELECT counter_field_value FROM table1 WHERE column1='this_article'
Add 1 to counter_field_value
UPDATE table1 SET counter_field_value= WHERE column1='this_article'
Combined ...
Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System ...
... specify 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 ...
... and restore them.
The Code Snippets: The Shopify Order Update notification
First create a CRM function called Shopify - Webhook - Order Notification. It's a standalone function but you'll need to ...
... + v_Page);
// maximum number of products per page
l_PaginationParams.add("per_page=" + v_PerPage);
// missing products if using default order by as date
l_PaginationParams.add("order=asc");
l_PaginationParams.add("order_by=id");
//
r_AllProduct ...
... photos and a bit of fuzzy logic.
I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process.
How?
As a high-level overview: ...
... });
*/
/* ************************************ */
/* Some non-Zoho JavaScript */
/* Set Copyright Year */
var today = new Date();
var currentYear = today.getFullYear();
$('footer ...
... Zoho Creator record ID of the order
Outputs: -
Date Created: 2023-03-06 (Joel Lipman)
- Initial release
Date Modified: ???
- ???
More Info: Error 7008: ...
... in Zoho Creator
Staff can access the report via Zoho Creator and export it to PDF.
They can then send the PDF to the supplier.
Technical Information
Automations in the background, on update ...
... users from saving a record without changing this. This script will round up decimal fields onload.
Inputs: -
Outputs: -
Date Created: 2023-12-13 (Joel Lipman)
- ...
... = ceil(v_MaxCount / v_PerPage);
info v_Pages;
Call with datetime criteria:
NB: You can't compare a date time value to a field that is simply of datatype: date
v_PerPage = 200;
v_CountCriteria ...
... zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error:
{
"code": 2945,
"description": "EXTRA_KEY_FOUND_IN_JSON"
}
How?
So the ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.