Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- How to get the system short date format using macros in Excel?
- Hi,I am in the process of converting date to yyyy-mmm-dd format i.e 2007-JUN-05 format. The problem i am facing is i have a date in MM/DD/YYYY U.S format in my excel sheet now if i change my system regional settings to some other country which has short date format as...
- Tags: arunnc84@..., Microsoft Excel, I.E
- Discussion threads 2007-06-05
- MySQL in a Nutshell: Date and Time Functions
- The ability to record dates and times in a MySQL database is a very common requirement. This paper presents the date and time functions for MySQL. Date and time data comprises only numeric strings, so it can be stored in a regular character column. However, by using temporal datatype columns,...
- Tags: MySQL, Column, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2005-04-28
- export xls to csv
- Hi,I'm looking for a macro in excel that lets me export to csv.The filename must be the name of the sheet combined with the month and year on the moment of export.Can somebody help me out? I've been searching for a few hours but no luck so far.Kind regards,PM.Might take...
- Tags: csv, Macro, C:\Documents
- Q&A 2006-05-01
- Round and truncate dates in Oracle
- watch outAlthough truncing a date is very common, I didn't know about the format parameter.Thanks.trunc(sysdate,'y') sure beats to_date('01-01-'||to_char(sysdate,'yyyy'),'dd-mm-yyyy')However while playing around I noticed something I didn't expect, using the 'd' format.I expected the output of trunc(sysdate,'d') to basically be the same as truncsysdate.Because truncing to a day would in my...
- Tags: bellyware, SysDate, Oracle Corp.
- Discussion threads 2007-07-25
- MS Access 2007 Time Stamps
- I am developing a database for which I would like Access to store 2 independent time-stamps:1) On record creation, never changes.2) On record update with a link to another field that stores the reason for the update.I would like my time stamps to be in the format dd/mm/yyyy, HH:mm if...
- Tags: Microsoft Office, Databases, admin@..., Microsoft Access, Microsoft Corp.
- Discussion threads 2007-04-18
- Change date format for all domain PC's?
- Does anyone know how I can change the date format to dd/mm/yyyy on all computers in the domain? There is nothing in Group policy. Help!You will need to create an administrative template and apply that via a GPO for the following registry keys:HKEY_CURRENT_USERControl PanelInternationalsLongDate which is usually in the format...
- Tags: Microsoft Windows, mveira@..., PC, windows
- Q&A 2005-03-10
- Digi Clock (widget)
- Digi Clock - Everything else is just a digital clock. Simply put, there's lot's of clock widgets, but I like this one the best." mrwebauthor. Two new features: Version Checker - looks for new updates of Digi Clock; Integrated Widgets...Popup Picture and Say It, have been the first widgets to...
- Tags: Clock, Productivity
- Software downloads 2007-07-23
- MS Access date formats
- I have a MS Access application on a central server available via Citrix to 30 or so users.Two of these users are seeing their dates displayed in 'American' format mm/dd/yyyy. The others are all OK. I have checked one of the 2 PCs - the regional setti
- Tags: software, brendan.donaghy@..., regional setting, Microsoft Corp., Microsoft Access
- Discussion threads 2006-11-22
- Time Stamp Capturing
- I want to capture time stamp for each cell entry in a particular column and i have around 150 rows in that column and i want when ever a value is entered in any row in that column i get the time of entry capture on any other cell and...
- Tags: amit.suneja@...
- Q&A 2006-05-15
- Change date format for all domain PC's
- Does anyone know how I can automatically change the date format for all computers on the network to the dd/mm/yyyy format?There is no group policy option available for this. HELP!!Isn't therea group policy setting for "regional settings"?Wrong forumThis is a tech. problem, in search of a solution.It properly belongs in...
- Tags: mveira@..., windows, PC
- Discussion threads 2005-03-10
- Access - Retrieval of Records by Part Date
- I am doing a membership database for our local RSL sub-Branch and need to be able to sort members by their BIRTH MONTH.I have tried different expressions but nothing is working.Any help would be appreciated.Robynre: Access - retrieval of recordsWhat format do you have their birth DATE stored in and...
- Tags: rob@..., BIRTHDATE, birth month, Microsoft Access
- Discussion threads 2007-11-12
- Regional settings continually change
- whenever I restart my XP Pro or Windows 98 computers the date format changes back to the USA format and I have to go into Control Panel and change them back to dd/mm/yyyy. I don't live in the USA and consequently don't like their format. How can I stop...
- Tags: Microsoft Windows, Operating systems, Geoff59
- Q&A 2005-06-27
- Create a Web form data format mask with JavaScript
- This article originally appeared in the Builder.com Web Development e-newsletter.In a Web application, it’s important to validate data before submitting it to the server. It saves you time and reduces network traffic. One of the most important parts of validating data is controlling input at the user level.In the past,...
- Tags: Scripting languages, Phillip Perkins, JavaScript, Web, numeric value
- Technical articles 2003-04-11
- Change the Date format for all the computers in a Domain
- Does anyone know how I can automatically change the date format for all computers on the network to the dd/mm/yyyy format?There is no group policy option available for this. HELP!!Change the date format by registryYou can export this key of registry, before set the date format that you needs.[HKEY_CURRENT_USERControl PanelInternational]Then...
- Tags: computer, date format, directory services., e-mail, group policy, it management, networking, security, software, trajesh84@...
- Discussion threads 2007-01-31
- Group policy
- We have a windows 2000 domain environment and using Group policy, now we want the date format of every client dd/mm/yyyyKindly tell me how to implement a group policy for this I shall be highly gratefulYou'll have to make a custom adm to pusha registry change to all your clients....
- Tags: group policy
- Q&A 2006-05-31
- asp:calendar in gridview isn't updating
- Hi Guys,I encountered weird problem where the similar code runs well in one page and partially working on the other.In both page, I have gridiview which has an edit command button. Page A is the working page, Page B partially working (can update the proj_name but not the from_date and...
- Tags: Databases, jackmuliadi@..., Page B., Page B, Container.DataItem
- Discussion threads 2007-08-28
- FileDate Changer (zip)
- The FileDate Changer utility allows you to easily change the Created/Modified/Accessed dates of one or more files. On FAT file system, the exact time of the "Accessed Date" is not saved as the other dates. Only the date (dd/mm/yyyy) is saved. The FileDate Changer utility doesn't require any installation process...
- Tags: Utility, FileDate Changer Utility
- Software downloads 2006-06-15
- How to write DISTINCT in sql's CASE ?,For that below query i am trying
- SELECT DISTINCT TO_CHAR(creation_dt,'MM/DD/YYYY') "Date of Creation",first_names "First Name", surname "Last Name", Section_Name "SSO ID",(CASE WHEN Authority_id = 'LEAD1' THEN 'Reconciler'WHEN Authority_id = 'LEADREV' THEN 'Reviewer'WHEN Authority_id = 'LEADRR' THEN 'Reconciler/Reviewer'WHEN Authority_id = 'LEADADMN' THEN 'Administrator'WHEN Authority_id = 'LEAD1' THEN 'Reconciler'WHEN Authority_id = 'LEADVIEW' THEN 'Browser' WHEN Authority_id = 'LEADCRE' THEN...
- Tags: Authentication/Encryption, SQL, m_shamanth, Authority_id, LEAD1
- Discussion threads 2007-08-31
- Validation of date format in MS Excel
- i want to give a validation of date format in MS Excel.my date format is mm/dd/yyyy.if sombody enters a different format,it will show error message.i tried with Data-->validation-->but if i give a date like 12345(with out '/'),it is automatically converting it to date.i don't want this .how can i do...
- Tags: Prince.Jose@..., excel date validation, project management, programming, off-topic, Microsoft Corp., Microsoft Excel
- Discussion threads 2007-01-14
- << Previous
- page 1 of 1
- Next >>
