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 ...
... 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: ...
... 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 ...
What?
Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks ...
... 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 ...
... clients set their due dates differently.
How?
The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are.
void fn_ReturnCurrentPaymentTerms()
{
v_BooksOrgID ...
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.