Assuming today is required, the following 24 results were found.
-
These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), 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",...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
progress... Create two cells with the default from and to dates: The formula for the first date of this week was =DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-WEEKDAY(TODAY())+2) Note the +2 is because our working week begins on Mondays and ends on...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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) =dateadd("d",-1, CDate("01/" +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
or to say the last Tuesday of the month. How? Quite easily. For the first Monday of the month, it is likely that even if today was the first day of the month and coincidentally a Monday, then we would want to specify the field date to be the first...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
}); }); */ /* ************************************ */ /* Some non-Zoho JavaScript */ /* Set Copyright Year */ var today = new Date(); var currentYear = today.getFullYear(); $('footer span.year').text(currentYear); Error(s) Encountered: Error Status 401...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
reserved expression letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear = DATEPART(YEAR,GETDATE())-18; -- 18 years ago from today -- GET RANDOM DATE VALUES SELECT @RandYear = ((@MinYear +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear = DATEPART(YEAR,GETDATE())-18; -- 18 years ago from today -- GET RANDOM DATE VALUES SELECT @RandYear = ((@MinYear +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods. Method #0: Update 2020 Tested in CRM and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
In this case, I want to display the current month with today highlighted. As I was trying to get my head round writing this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code....
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
was wrong. Contrary to what the documentation that says "This task can be used in the following events", effective as of today October 19, 2020, I have not found a place you cannot use this deluge script. The ZC_SUBFORM_250 error is because I am trying...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
using the Location of your product variant (where "1234567890" is the location ID) to get the recent 10 products updated today: { productVariants( first: 10 reverse: true query: "updated_at:>'2022-02-14T00:00:00+0000'" ) { edges { node { id price...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// // recurring pattern (this one sets to everyday from today) m_Pattern = Map(); m_Pattern.put("RRULE","FREQ=DAILY;INTERVAL=1;DTSTART=2022-03-02"); m_ScheduleMeeting.put("Recurring_Activity",m_Pattern); // // send invitations to participants?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Cannot send this quote."; } return v_OutputMessage; Update: What is the URL to download the PDF in Zoho Books? Found this today so thought I'd add it to this article: Invoice: https://books.zoho.com/api/v3/invoices/pdf?organization_id=&invoice_ids=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is an article documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead record to an opportunity (or Deal) record. If you are using...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 will fail... Why? I have a function to push a ZohoCRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
BY "Modified Time" DESC /**** Pseudo: Select Modified Time of Record If Modified Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago Use URL of the image representing...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
with whatever character. I just put NULL because I wanted an empty row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more PHP but since becoming an analyst, I do more at the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB