Over 1 million tech questions and answers.

date format in script

Q: date format in script

hello,
I want to format date in my batch script so that I may use it as file name.How can I format date from default formatting to dd/mm/yy ?

RELEVANCY SCORE 200
Preferred Solution: date format in script

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: date format in script

These instructions should be what you want: http://findarticles.com/p/articles/mi_zdpcm/is_200406/ai_ziff128194

Will only work in XP.
moper

Read other 2 answers
RELEVANCY SCORE 59.2

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

Read other answers
RELEVANCY SCORE 59.2

Hi! Does anyone know what is the format of the date in the field "(battery) Manufacture Date" informed by Lenovo Vantage (Hardware Configuration > Energy)? It seems not to follow Windows setting. In my case, it is set to Brazilian Portuguese DD/MM/YYYY, but there is not a leading "0" in the returned value (see attached image). Does it really disregard the Windows setting and presents it in a fixed format (maybe American English)? When was my battery manufactured (Oct. 07 or July 10)?Thanks in advance.  

Read other answers
RELEVANCY SCORE 58.8

Hi all,

I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control
Panel I have the short date format set to ddd dd/MM/yyyy and the example is shown as Fri 05/11/2010, but in Excel all the date formats are shown with space separators, e.g. 14 03 2001! I don't think it's an Excel problem though as in Windows Task Scheduler
the dates are shown with spaces there e.g. '19:25 on Mon 01 11 2010'. The date by the clock though is shown correctly with slash separators!

I know in Windows XP you can select the date separator from a drop-down list, but this option seems to be absent in Windows 7. Under HKEY_CURRENT_USER\Control Panel\International in the registry, sDate was set to a space, but changing that to a slash (and rebooting)
didn't fix the problem.

Does anyone have any ideas please what's wrong and how to fix it?

Thanks
Steven

A:Date format using space as date separator rather than forward slash!

Hi Steven,
 
Thanks for the post!
 
When you set the Short date to ddd dd/MM/yyyy, the date by the clock is shown with slash, however, the date in Task Scheduler doesn’t show the slash. This behavior
is by design. When you double click the time and the trigger tab (for example) in task scheduler, the details are shown with slash.
 
When you change the Short date to dd/MM/yy, the date in the Task Scheduler and the clock become the same.
 
For the Excel date problems, I recommend you ask this question in
Office Forum.
 
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and
other communities who read the forums regularly can either share their knowledge or learn from your interaction with us. 

 
Thanks for your understanding and cooperation!
 
Best Regards,
Miya Yao
 This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer
your question. This can be beneficial to other community members reading the thread.

Read other 5 answers
RELEVANCY SCORE 58.8

Hi all,

I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control Panel I have the short date format set to ddd dd/MM/yyyy and the example is shown as Fri 05/11/2010, but in Excel all the date formats are shown with space separators, e.g. 14 03 2001! I don't think it's an Excel problem though as in Windows Task Scheduler the dates are shown with spaces there e.g. '19:25 on Mon 01 11 2010'. The date by the clock though is shown correctly with slash separators!

I know in Windows XP you can select the date separator from a drop-down list, but this option seems to be absent in Windows 7. Under HKEY_CURRENT_USER\Control Panel\International in the registry, sDate was set to a space, but changing that to a slash (and rebooting) didn't fix the problem.

Does anyone have any ideas please what's wrong and how to fix it?

Thanks
Steven

A:Date format using space as date separator rather than forward slash!

Hi,

The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


OS

Read other 9 answers
RELEVANCY SCORE 58.4

Hi,
I want to format the date of Share Point list, I don't want to create Calculate formula column to format the date because. We cant change the existing date in Calculate formula date.
For Example
Existed date : 12/8/2018. here 
Calculate date : 12 Aug 2018
We cant edit the calculate date, but we can edit the Existed date.
While displaying the Calculate date it is disabling the Calculate date.
I want to change the date of Existed date and format into calculate  date.
"Here I have two question
1. Can we format the Existed date.
2. I know it is not possible to edit the Calculate date. But just asking any possibility is their to edit it."

Read other answers
RELEVANCY SCORE 57.6

I am setting up a spreadsheet for the year and want to use it year over year. I have the cell set up with the date (1/1/2011) with a format of d so that it displays the date as Sat, 1/2/2011 - Sun, etc. Since I want to use this year after year with minimal work and I want to highlight the cells that are equal to Sat and Sun, how would I set up that formula. I tried the basic =A1="Sat" and without quotes but it just returns #NAME. I know working with dates in formulas is different but can't figure out what I need to use.
 

A:Solved: Excel 2007: conditional format when date displayed as format d

Read other 8 answers
RELEVANCY SCORE 56.4

I'm backing up everything from my C: drive to drive F: using ntbackup, but first, I'm formatting the F: drive. For the formatting part, I want my script (simple batch file) to make it just happen--I don't want to respond to two prompts before formatting each time I run it. Any ideas?When I do this:format f: /fs:ntfs /v:"Backup_160"It prompts me to enter the volume label for this drive. Then it asks if I really want to erase the thing. I am thinking a "/Y" tacked onto the end will suppress the prompting about whether I want to erase it. What about the volume label prompt? I thought the "/v:"Backup_160"" was supposed to answer this question, but it doesn't seem to. Whether I remove the "/v:" parameter or leave it there, it always prompts. (Note that in this case, "Backup_160" was both the old and new name of volume F:; that's what I want it to always be called when I backup.)Also, what's the best way for me to overwrite the old backup file (Backup.bkf) each time with the new one, via batch file? Is this what the /T and /G switches are for--to overwrite an old backup file?Here's what I used last night:format f: /fs:ntfs /v:"Backup_160"ntbackup backup c:\ /n "Backup.bkf created 10/16/2006 at 1:08 AM" /v:yes /r:no /rs:no /hc:off /SNAP:on /m normal /j "Weekly System Backup" /l:s /f "F:\Backup.bkf"Thanks,Hotshot309

Read other answers
RELEVANCY SCORE 55.6

As above, I recently upgraded to XP from ME and since then the date format in the Received column of Outlook 2000 is in US format while in the Control Panel, everything is set correctly to the UK format.

Is there any way of forcing the issue in Outlook to make it behave as per the Control Panel?

Cheers all.
 

A:XP is on UK date format, Outlook 2000 is on US format

Hi Simes

After a cursory look through Outlook,
How does the time display in Outlook 2000,
Tools > Options > Calendar tab > Time Zone?
 

Read other 3 answers
RELEVANCY SCORE 52

This is a two part question. First, I need to create a logon script with the date field, but don't know how. All workstations are NT4, on an NT network. I want the batch file to run only on a particular day. If it is not that particular day, I want it to do nothing. I'm not very strong when it comes to "If, Then" statements so a lengthy explanation is welcome.

Second, can anyone recommend a book for writing logon scripts in NT?

Thanks for the help,

Hill
 

Read other answers
RELEVANCY SCORE 52

Does anyone know of a script that counts down days until a special even that can be used on a web page so that the number of days to a certain date is automatically updated? This is the kind of thing that was used when counting down to the Y2K.

Thanks,

counting
 

A:(ttt) Date Countdown Script

Read other 6 answers
RELEVANCY SCORE 51.2

System: WinXP and Win98SE

I need help with a script or vbcode that will automatically backup a file or files daily. The current format (so that I can identify the date it was backed up) is: date-filename.bak (ie. 040831-filename.bak).

I would prefer the date be generated automatically, but if there is a dialog box that appears so that the user enters the date manually, that would be fine also.

This particular need is going to be used as an intermediate step to the weekly backups of the datafiles, and is not intended to take the place of the full backup procedure. But I need a step in there incase the the file becomes corrupt, and the user does not know it until several days later, they can go back one or two days, not an entire week, to use as a starting point on the data.

Any help would be greatly appreciated.
Thank you.
 

A:Solved: Automated date script

Read other 16 answers
RELEVANCY SCORE 50.4

I have just had my pc at work upgraded from XP to Vista, and now all my dates are in the wrong format. For example if I type in 19/11/14 on my database, it automatically changes to 14/11/2019. I've checked the global settings, and they are set to English, United Kingdom, Short date. Our IT guy has discovered the date is wrong when he checks it using the cmd prompt, but can't seem to get it to change. All previously created spreadsheets etc., have change so the dates are wrong. Any advice on how to change it in DOS?
 

A:Date format

Go to the Region settings found in Control Panel and check your Short date format make sure you set it to dd/mm/yyyy.
 

Read other 2 answers
RELEVANCY SCORE 50.4

Hi,

The default date format is MM/DD/YYYY. How can I save and display as DD/MM/YYYY? This is very important cos' after I entered in DD/MM/YYYY, Access still convert it as MM/DD/YYY.

Thk a million!
 

A:Date Format

Form Access Help
Microsoft Access can display a wide range of international formats. To help ensure consistency among applications, Microsoft Access uses the regional settings in Microsoft Windows Control Panel for the predefined Number and Date/Time formats. If your data isn't displayed in the right format for your country/region, change the regional settings specified in Control Panel.

But you can set them manually as well.
 

Read other 1 answers
RELEVANCY SCORE 50.4

i am using windows 2000 platform. i want to create a dos batch files that would create a backup or archive files.

e.g.

Code:

d:\data\in
09/05/2006 05:46 PM 12,747,232 file01.txt
09/05/2006 05:46 PM 335,320 file02.txt
09/05/2006 05:46 PM 287,742 file03.txt

when the batch runs it will check for the current system date and will copy the files to another folder as

d:\archive\in

09/05/2006 05:46 PM 12,747,232 file01-09062006.txt
09/05/2006 05:46 PM 335,320 file02-09062006.txt
09/05/2006 05:46 PM 287,742 file03-09062006.txt

how do i achieve this? thanks.
 

A:Date format in DOS

It has been so long since I have worked in MS-DOS it is not funny but here is a page that might be of some help to you

http://www.chebucto.ns.ca/~ak621/DOS/Bat-Adv2.html

Have fun and enjoy
 

Read other 3 answers
RELEVANCY SCORE 50.4

Is there a way to change the date format the machine uses.
For example, my machine organizes pictures by date, but mm/dd/yyyy doesn't really facilitate finding anything.

yyyy/mm/dd would be much better.

TIA

A:Date format

This might be what you are looking for. Click here

Read other 1 answers
RELEVANCY SCORE 50.4

Hi, i'm new here and i need a script like in this old topic: https://forums.techguy.org/threads/...te-and-time-before-starting-a-program.985824/ , but i need for windows 10 with automatic date and time adjust, coz i have a laptop and each time i close the time is delay, i try all tutorial from internet to make the setings and to change bios battery with a new one and the problem is the same. and the only way to ajust time is to click right on time and go to ajust and press update.

if you can help me to make a .bat like in that old topic but to work on windows 10 with automatic adjust time and date to execute by click on it each time after windows is open will be great.
 

Read other answers
RELEVANCY SCORE 50

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 5211 MB; D: Total - 36294 MB, Free - 8687 MB;
Motherboard: ECS, G41T-M
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled

Hi All
Im using the attached vba code and would like to use the "title" format function to show the date of the day in the User Form, is it possible and is there any help on this matter.

Thanks in advance
Rusty
 

Read other answers
RELEVANCY SCORE 49.6

I am running WinXP-pro. When I print checks using Quicken 99 - the date always shows up in this format: "1/1/2006." (It never used to act that way when I was running the program on Win95). I don't see the "1/1/2006" in my long-date or short-date format in the control panel. And I don't see any formatting options for the date in the Quicken 99 program. Has anyone had this problem? thanks, thsh6
 

A:Date format in Quicken 99

Did you check Regional & Language Options in control panel? Beside your language (for instance English (United States) click on the Customize button, click on the last tab - Date - to change your date format.
 

Read other 1 answers
RELEVANCY SCORE 49.6

Can anyone tell me how to change the format of the date in a footer. I would like in to read "Jan-27-04"
 

A:excel date format

If you use the Custom Footer option, you can type in whatever you like. I could not find a way to enter the data so that it updates based on your computer's internal settings,
 

Read other 2 answers
RELEVANCY SCORE 49.6

Hi,

There's a network, WinXP clients with a NT4 networkserver. When a user login (domain user) everything goes fine. But he or she want to change the date format to dd-MM-jjjj (Dutch) format. Keyboard settings, Dutch with US-International keyboard. That is not possible, an error message said "Not a valid date format". When I login as an administrator, there is no problem. Give (domain or local) user administrator rights, does'nt solve the problem.

Any ideas?

Read other answers
RELEVANCY SCORE 49.6

Hi

I have a list of dates in Excel in US date format and I can't seem to get them to switch into UK date. I've tried the classic re-formatting and putting the data into notepad etc. Sure its pretty easy.

Any ideas?
Thanks
 

A:US to UK Date Format in Excel

Read other 7 answers
RELEVANCY SCORE 49.6

I was searching for a way to enter dates such that they are interpreted in the US (not UK) date format, i.e. mm/dd/yy not dd/mm/yy. It was unresolved in this closed thread http://forums.techguy.org/business-applications/910502-us-uk-date-format-excel.html
Since I've solved it, I'd like to share the simple solutrion with interested parties:

1. Close all Office applications.
2. Open Control Panel>Clock, Language, and Region>Region and Language>Change the date,time, or number format.
3. Under Formats, use the drop down to select "English (United States)".
4. Then close and open Excel. From this point on entering 7/1/11 will give you 1 July 2011, and not 7 January 2011.

Don't forget change it back afterwards (unless of course you're moving to the US
 

A:US to UK Date Format in Excel

You can also format the cells to your needs

Use the custom format
dd/mm/jjjj;@
mm/dd/jjjj;@

The ;@ forces the date to that format, you enter the date as you normally do so if it's Brittish dd/mm/yyyy and it will change to mm/dd/yyyy if the format is set to mm/dd/jjjj;@

What has to be clear for the use tis that he she has to enter the date as he knows ir should be

If they are used to entering day month year they will have to do that even though the format says different.

because February 1 2011 entered as 1/2/2011 will become 2/1/2011 in mm/dd/jjjj;@ format.

I hope I have been able to explain it,
The advantage is that you don't need to rememebr that you changed you country settings
 

Read other 3 answers
RELEVANCY SCORE 49.6

Hi, this should be easy, how do I determine if the system date format is DD/MM/YYYY or MM/DD/YYYY.
 

A:VB get System Date Format

I had it figured out some time back but don't remember now. Although as far as I am remember, my method was not full proof and there was no way to tell a date format on days like 1st Jan, 2nd Feb, 3rd Mar, etc.

But still just give me a day or two and I will try to find it out.
 

Read other 3 answers
RELEVANCY SCORE 49.6

I have a legacy application (Borland Paradox) that ran fine on Vista, but when ported to a Windows 7 PC running under Windows Virtual PC, it kept throwing
an error when querying dates. I have managed to track this down to the European format (DD/MM/YYYY) being interpreted as American format, i.e. MM/DD/YYYY. This is in spite of having the European format set correctly in both Windows 7 & the Virtual XP mode.
Is there a way out of this conundrum please ?

Read other answers
RELEVANCY SCORE 49.6

When I create a footer in Excel 2000 the date format is always 12-03-2003. I can change the date format in cells with excel but not in the footer. I would like to be Dec-02-2003. I also change my setting under control panel/regional settings, this still doesn't seem to work. Does anyone know how to do this.
 

A:[Resolved] date format

Read other 14 answers
RELEVANCY SCORE 49.6

I just installed a split database on a non-profit organization's computer. In a table that contains date fields, I had set the date format to "m/d/yy" when defining the table fields on my computer. When I subsequently designed the input forms for the table, the dates show correctly in that format.

But when I installed the database on the client's computer, the dates show in "m/d/yyyy" format. I thought it might be because that computer's Regional Date Options were set to that format. However, I just experimented on my computer, changing the Regional Date format to "m/d/yyyy", then opening the database to see if the Regional format overrode the format defined in the table. It does not.

So. . . any idea why despite the date format being defined in the table as "m/d/yy" that on the client's computer, it displays as "m/d/yyyy"?
 

A:Date format not working

Read other 9 answers
RELEVANCY SCORE 49.6

What format do I use when I type 010106 and want it to appear as 01/01/06?
Thanks.
 

A:Date Format in Excel

Read other 7 answers
RELEVANCY SCORE 49.6

I like printing the date on the bottom of my email. But it always comes out like "07/02/03", I do not like this I would rather it look like this "Jul-02-03". At least the month with letters instead of digits. Does anyone know how to do this? And will it be the same in excel and word?

Thanx
 

A:windows date format

What mail program are you using?
 

Read other 2 answers
RELEVANCY SCORE 49.6

I live in the UK and want to use the day-month-year format in displaying the date.

In Control Panel, Region and Language, Additional Settings, I've changed my Location and Keyboard, and set my date format to 'd.MMM.yy' (short) and 'dd MMMM yyyy' (long). In the W7 betas, this gave me a day-month-year format in all programs.

In the RC, I get the format I want in the notification area, Windows Explorer and Directory Opus, but my other shareware programs (e.g. Macro Express and Clipmate) display American date format in their listings. I installed them in Compatibility Mode.*

Does anyone know a fix for this? - in the registry, maybe?

Mary

A:UK date format in Windows 7 RC

  
Quote: Originally Posted by MBernard


[...]

In the RC, I get the format I want in the notification area, Windows Explorer and Directory Opus, but my other shareware programs (e.g. Macro Express and Clipmate) display American date format in their listings. I installed them in Compatibility Mode.*

Does anyone know a fix for this? - in the registry, maybe?

Mary


Just to clarify, does this mean the date within these programs appears in the American format, or (say) in the Programs and Features 'Installed On' column?

If it's the former, I think the only way to make the changes is in the options for those shareware programs, rather than in Win 7.

Read other 5 answers
RELEVANCY SCORE 49.6

Hi All
Is there any way to give access to end users only to change Date format(from dd/mm/yyy to mm/dd/yyyy and vice versa). I don't want them to change the date just the date format.
Regards
Bharath

Read other answers
RELEVANCY SCORE 49.6

Hya folks,

I need to enter a date in a table in access, however instead of using a normal input mask of DD/MM/YY I'd like to use the format DD.MM.YY as this is in line with the date format of all our bespoke software.

I've tried editing the input mask list to no avail. I'd like to keep the field as a date/time field as we need to do queries using it.

Any ideas gratefully recieved .

Thanks

Gogs
 

A:Date Format in Access

Read other 7 answers
RELEVANCY SCORE 49.6

I was viewing a recently closed thread and was interested in a similar task.

I would like to test the ability for my program to not be manipulated by any sort of time scripts created but first need assistance in creating a simple script that would set the system time to a STATIC time or maybe -5 minutes (or even a loop that sets the time). I have the script that syncs the system time to a time server but wanted to see if anyone would provide a sample script that may possibly still be able to change the time in this app.

Here's a good example.

User1 logs in, clicks a button which timestamps and saves this time to our database. This timestamp is in reference to a phone call and we want to be exact or very close to recording the time of the call.

What I DON'T want is for someone to run a script that resets the time or manipulates it, that's what I'm looking to test. Though if I can prove it can be reset we will rewrite this module. Please help me with any sample scripts I could run, maybe a .bat loop file that repeatedly resets the time, etc. I'd REALLY appreciate all examples and thank you in advance
TestGuy
 

Read other answers
RELEVANCY SCORE 49.6

Not sure if this is the right place to post my query but here goes.
When trying to troubleshoot a pesky Vista upgrade problem within various folders, including synchronizing the computer time, I stumbled upon the attached JavaRuntime script which shows a 'last accessed' date of 9/03/2073. Have attached a screen jpg screen dump.
Unless I'm rip van winkle, the last time I checked, currently it is 2009.
My questions are - where does this date come from and is this date component of 2073 a cause for concern.
Any advice appreciated. Many thanx. Lucee

A:JavaRuntime Script access date displays year as 2073

Hello lucee and welcome to TSF

Usually the last accessed time is generated by the PC using the current time set and stored in the CMOS (BIOS Settings),

If you are having issues setting the time or the CMOS is faulty and the time cannot be set then the last access time will be completely incorrect and far fetched,

What is the issue your trouble shooting to cause this java error?

Regards



Craig

Read other 2 answers
RELEVANCY SCORE 49.6

I was wondering if there was a way to create a set of folders in a specific directory according to a date range that i input.

ie.

Select start date 2011 10 01

select end date 2012 10 01

Select Output path of c:\users\XXXX\desktop\export data

and it creates a folder for all days from 2011 10 01 through 2012 10 01 and places them in the output path i have set for it.

any help would be greatly appreciated.

Thank you

A:Is there a Script or batch file that can create folders by date range

Welcome damjohnron to the windows 7 forums.

Here are some snippits of a dos batch file that will create a directory with the datek and tell you if it already exists.


set DATEST=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
echo %datest%
rem if it looks ok, then you can press enter to continue
pause
if exist %homepath%\documents\%datest% goto dup1
md %homepath%\documents\%datest%
rem the pause can be taken out if you wish.
pause
go to end
:dup1
rem you already have done this.
pause
:end

you can change the path statement to the directory you wish.

This batch file can be run each day that you want to create a new sub directory.
There are other ways to do this but a bit more complicated such as reading an external
text file for the directory names.

Rich

Read other 4 answers
RELEVANCY SCORE 49.2

Hi guys,
I'm a total newb to scripting, so I wanted to know if it is possible to write a .bat file that does the following:
__________________________________________________________________________________________
Change system time to 3 o'clock
Change system date to 11 March 2011
Run program at J:\Softwares\Folder Z\Z.exe
__________________________________________________________________________________________
So, can you please help?
Thanks in advance,
Rajas
 

A:Solved: How to write a script to change date and time before starting a program

Read other 6 answers
RELEVANCY SCORE 49.2

I'm trying to create an order form that will have some auto fill fields such as date, consecutive order number etc...

The first snag is the the date cell. Ideally I would like it to auto fill this field with the days date upon opening the spreadsheet, I couldn't figure that out so under 'format cell' I designated it as 'date' and chose dd/mm/yy as the format.

The weird thing is that when I enter the numbers for the date in that cell it show up as a completely different date. Example, I click on that cell and type: 041206 for todays date and the cell displays 10/24/12 ?? What the heck is that?

Thanks in advance!

Steve

A:Excel Date Format Is Screwy?

I have had, what I think to be similar problems and when you set the format to something specific (like mm/dd/yy) that is how you have to enter it, including the "/".

If you do it without the slash then excel interprets it differently and changes it. I am not sure why it does this or what it is doing but I do remember that typing the date exactly how the format was set ... solved my problem.

Read other 7 answers
RELEVANCY SCORE 49.2

I have a column that I would like to change from text to date in Access. The dates are in one column and look like this: 5/20/04-0-6/20/04. When I try to change the format to the d/m/yy style, Access deletes all my date rows. Is it possible to have a date appear in one column as a time interval?
 

A:Date Interval Format in Access

bigceedee,

I stand to be corrected, but my answer is no. You can only have one date in a date field. The only way I can think to get round this is shown in my attached sample.
 

Read other 2 answers
RELEVANCY SCORE 49.2

Hi,

I have a small php script which reads records out of a MySQL table and displays them as an HTML page, by date order.

It's easy to make the dates come out as 03-05 or 04-15. I want to show them as Mar 5 or Apr 15.

Here's the short script with my notes as to what works and what doesn't:

<html>
<head>
<title>Events List</title>
</head>
<body>
<h1>Upcoming Events</h1>
<?php
@ $db = new mysqli('localhost', 'xxxxx', 'xxxxxxxxx', 'rsvp');
if (mysqli_connect_errno()) {
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select Title, Date, Notes from events where Date >= '2010-03-22' order by Date ";
$result = $db->query($query);
$num_results = $result->num_rows;
for ($i=0; $i <$num_results; $i++) {
$row = $result->fetch_assoc();
echo "<h2>".htmlspecialchars(stripslashes($row['Title']))." - ";
$datetime= substr(htmlspecialchars(stripslashes($row['Date'])),5);
//
// echo $datetime; works OK at this point but gives 03-02, 04-15, etc.
//
// Next line was to give date as Mar 3 or Apr 15, etc.
//
// echo date_format($datetime, 'M j') ;
//
// Instead it gives various errors as I try quotes, double quotes, etc., etc.
// Mostly:
//
// Warning: date_format() expects parameter 1 to be DateTime, string given ... on line 22
//
//
// Tried lots o... Read more

A:Solved: PHP Date read and format

This did it:

for ($i=0; $i <$num_results; $i++) {
$row = $result->fetch_assoc();
$dt= substr($row['DateTime'],0,10);
$new_date = date("Y-m-d", strtotime($dt));
$prnt_date = date('M d', strtotime($dt));
if($new_date >= $start_date) {
echo "<h2>".htmlspecialchars(stripslashes($row['Title']))." - ";
echo $prnt_date . "</h2>";
echo htmlspecialchars(stripslashes($row['Notes']))."<br>";
echo "</p>";
}
}

Actually, since the query was already for date >= today's date, the logic loop is not needed...but it took me the day to realize that the error (mine, of course) was I was comparing a date formatted as '2010-03-24' with a date formatted as 'Mar 24' .
 

Read other 1 answers
RELEVANCY SCORE 49.2

Hi all,

I have a report which is grouped by Month. The month is derived in a query using the month([date]) function. It comes up fine as the numerical month eg Jan = 1, Feb = 2 etc. In the report I want it to show the month name. I have tried the monthname function and format([month],"mmmm") but it comes up as January for all of them !!

I am about to throw the laptop out the window so would really appreciate help on this ! I am sure it is something really simple I have missed

Thank you
 

A:MS Access Date Format Issue

Read other 6 answers
RELEVANCY SCORE 49.2

I have not found a solutions which worked, datevalue returned #value etc. The basic problem is if your system date is not according to the date format in your text date column. So if you have set it to ISO, starting with the year, datevalue will not work etc.
This procedure worked fianally:

If the date format is like '12/31/2011 (US Format)
1. Change date format in CtrlPanel Regional & Language Option to the corresponding format, in this case mm/dd/yyyy
2. Select column with dates
3. Format Cells General.
Dates will change to Datevalue 40908 (Nbr of days since 01/01/1900)
4. Format Custom i.e. ISO Format yyyy/mm/dd (which really should be used everywhere)
5. Voila 2011/12/31
6. Change date Format in CtrPanel back to your Format
 

Read other answers
RELEVANCY SCORE 49.2

I have a column of dates in dd/mm/yyyy format, yet nothing I do lets me sort from oldest to newest.
Basically it doesn't recognize the column as having only dates, therefore only allows me to sore from A-Z.
I have tried what was posted on a few other forums, such as copy-pasting the column in notebook and
then back to excel. I've also tried the text to column wizard, with no help.
I've tried creating entirely new excel files and copy-pasting the dates there, either directly
or copying to notepad and then to the new spreadsheet. Nothing seems to work.
 

A:Can't change date format properly

they are not formatted as dates and probably text

can you attach here ?

click on the date cell and change the format to number or general
you should see a number like
42293
which is today 16th Oct 2015
 

Read other 5 answers
RELEVANCY SCORE 49.2

Having problems with the date format on our Citrix Server

Problem Details:
Office Apps are not using the System Default Date Format.
Regional Options show English (United States) as the locale - dddd, MMMM dd, yyyy as the long date format and that's what we want. However, when you use Word or Excel it keeps defaulting to English UK settings
E.g Thursday, 10 January 2008

This only seems to be affecting MS Office though

Setup:
Windows 2000 SP4 Server
Citrix Metaframe XP FR3
MS Office Professional 2003 SP2

Recent Changes to System:
Server was in an NT4 domain and was just migrated to an Active Directory Domain. Users are still logging in with their NT4 domain credentials though (problem still exists when I login with my AD credentials).

Things I have checked:
Regional Settings
Registry Setting (HKCU/International)
Any ideas?
 

A:Solved: Office Date Format

Wonder if this is coming from the "Microsoft Office 2003 Language Settings" that are located in Start>All Programs>Microsoft Office>Microsoft Office Tools...

I played around and found I could force that date format if I set language to English UK.

Hope this helps,

MBN
 

Read other 2 answers
RELEVANCY SCORE 49.2

Hi
I want change format Time& Date but when i change country to a format special for example English (united state) after click OK button at once return to previous format
help me!

A:Not Change Format Time & Date

Time Format - Change

Date Format - Change

Date and Time - Change

Format Regional Language - Change

Read other 1 answers
RELEVANCY SCORE 49.2

Hi Guys,

Anyone encounter this error problem while changing the date format ?

Error :-

One or more of the characters you typed in this field are invalid.
Try typing different characters

Using administrator right i have no problem changing the date format.
If i use my profile i cannot change even i got the access right same as admin..

what is wrong over here ?

Thanx for the help.
 

A:Error while changing Date Format !!

Could be a corrupt user profile. Try creating a new profile and copy data from the corrupt profile to the new.

Info: http://support.microsoft.com/kb/811151
 

Read other 1 answers