Question:
Hello all,
I am working on a simple custom function (really simple) so I can test some different formulas to extract data based on dynamic date ranges. I have stuff that always fails in January because I haven’t properly accounted for the change in years, so this year I’m trying to fix it once and for [...]
Question:
Now is 1:20AM 2010-01-05 and I use php function date() to get today
$time = date(‘Y-m-d’);
but it gives me yesterday 2010-01-04.
Please help me, I need today’s date.
Solution:
As far as I can see there are 1 day of difference between you and your server.
So to fix the time diference:
<?php
echo date(“d-m-Y”,time()-86400);
?>
Question:
Hello,
I am working on a C# project to process some jpg images using the exif data. I have many questions, but my first is simply interpreting the binary file using a hex editor. The exif format specifies the DateTimeOriginal at 0×9003. When I open the binary file in a hex editor, I see column headings [...]
Question:
Hi experts
I am attempting to automate the creation of a commonly known shopping cart database (which usues mysql) using Micorsoft Access and VBA code. This means I am forced to use legacy tables which are dictated by the third party back end setup. It also means there are things which do not quite match up [...]
Question:
Hi,
I’m running Joomla on an upto date Mac OS X 10.5 Server. The MySQL database is on a Windows 2003 Server.
This was working fine till a few days ago but has been working for over a year.
PHP Date function is returning the year 2000.
Within Joomla, all the articles are not showing up because they were [...]
Question:
I have a date field (YYYYMM) in SQL that has the date in YYYY-MM-DD format. Is there a way to write an update statement to change ALL day values in the column to 01?
Ex:
Current – 2008-08-15
Update – 2008-08-01
Solution:
sorry it should be
update table
set datefield = dateadd(day, -14, datefield)
where datepart(day,datefield)=15
and if you want for all days
update table
set [...]
Question:
We have a Vacation/Time Off calendar on our SharePoint 3.0 site (named Bobber). It used to show begin time and end time as the following:
Matt Albrecht Day Off 9/21/09 12:00AM 9:21/09 11:59PM
or
Matt Albrecht Honeymoon 9/21/09 12:00AM 9/30/09 11:59PM
I thought it was a little ridiculous to show the time, but there isn’t a view that hides [...]
Question:
I have a web part that I would like the title to contain the current date. For example, “Today’s Schedule for September 1, 2009″
Is it possible to make the title of a web part a formula that would change as the date changes?
Solution:
Hi,
After all the necessary controls are added in the CreateChildControl method, just write
this.Title [...]
Question:
I am trying to create a text file using a batch file. I format the text file then open it for the user to make entries into. I want to save the file name as follows.
computername_InstallerName_Install_Log_Date_Time.txt
I have tried a number of ways and it seems to save it and while I may get the [...]
Question:
Hi there,
I’m trying to use the MaskedEditExtender to validate the user input dates. My problem is that the dates need to be in the YYYY-MM-DD format and the MaskedEditExtender doesn’t seem to like that.
I changed the culture to CultureName=”fr-CA”…the dates show up like they should but I get invalid date all the time…even if I [...]