Vbs date created file

ROFL I just spent about two days trying to get this sorted and the second I suss it out, you reply with exactly the same answer I came to - well someone else came to and I copied from Though I guess you can measure your response time in seconds rather than days!! Many thanks really appreciated!! No worries mate, any time. Joined May 15, Messages I'm looking for something similar for Win7 in Excel However I need the " DateTaken " date. I'm trying to create a spreadsheet that will let me rename my photos using the date I took the picture since Creation and Last Modified will not work for me.

Can you help me with this? Since this is an available field under Windows Explorer in Win7 , so I don't understand why I'm having so much difficulty figuring this out. AshJT New Member. Joined Aug 18, Messages 1. Hi I'm also looking at something similar to this - I can read metadata from a file by using fso code, but is there a way to change this data? Ideally I want to change the Author data field. Any ideas? You must log in or register to reply here. Similar threads B. Solved Select Sheet from External Workbook.

Value, "D. BuiltInDocumentProperties "Last save time". If you intend using the last method, then you should trap an unsaved document or it will crash untidily e. If Len ActiveDocument. My word-document is a template based document. So it will earn this properties from the template. But you are right, if i create a plain word-document: The «Last save time» property don't exist until i save the document.

All documents are template based. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta.

New post summary designs on greatest hits now, everywhere else eventually. Linked 1. Related Hot Network Questions. GetDayOfYear Returns the ordinal number of a day in a year. GetMonth Returns the month number of the specified date. GetYear Returns the year number of the specified date.

IsLeapYear Indicates whether the specified year is a leap year. Now Returns the current date and time. SetDateElements Returns the Date variable having the specified year, month and day. SetSystemDateTime Assigns the specified date and time as the system date and time.

Today Returns the current date. One more object, aqConvert , provides methods to convert strings between date values and their string equivalents: Method Description DateTimeToFormatStr Converts the given date value to a string using the specified format. DateTimeToStr Converts the given date value to a string. StrToDate Converts the specified string to a date value.

Here is a list of built-in functions that can be useful when dealing with dates: Function Description CDate Returns an expression that has been converted to a Variant of subtype Date Date Returns the current system date. See a note below to learn about the format of date values in VBScript. DateAdd Returns the date to which the specified time interval has been added. DateDiff Returns the number of intervals between two dates.

DatePart Returns the specified part of a given date. DateSerial Returns a Variant of subtype Date for the specified year, month, and day. DateValue Returns a Variant of subtype Date. Day Returns a whole number between 1 and 31, inclusive, representing the day of the month.

FormatDateTime Returns an expression formatted as a date or time. IsDate Returns a Boolean value indicating whether an expression can be converted to a date. Month Returns a whole number between 1 and 12, inclusive, representing the month of the year. MonthName Returns a string indicating the specified month. Now Returns the current date and time according to the date and time set on your computer. Weekday Returns a whole number representing the day of the week. WeekdayName Returns a string indicating the specified day of the week.

Year Returns a whole number representing the year. These strings are automatically converted to the floating-point variant format when required. In most cases, you can pass a VBScript date to a TestComplete routine or vice versa and get the correct results. We can use this method to get the exact number of days in the desired year: VBScript.

The code below demonstrates how to use these methods: VBScript. Is this page helpful?