Database Search

TechHome

• Check Between Two Times UDF
• Convert NTP to YMDHMS
• Convert Time to Greenwich Standard Time
• Converting FileTimeCodes to YmdHms and back
• Day of year and more time UDFs
• Daylight Savings Time Code
• Determine Leap Year
• Even More Assorted TimeDate UDFs
• Find Easter
• Find Monday UDF
• Force Valid TimeDiff Strings
• Format Current Date and Time
• Hex2Date
• Is Date Valid
• IsDate UDF
• ISO 8601 Week Number to Date
• TimeAdjustCurrentZone
• TmsHms to User Local Format UDF
• UDF Time Date Display Conversions II
• UDF Time Date Display conversions
• udfStrpTime Converts Human Readable Date
• Universal Time to Local Time
• Week of Month

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

udfStrpTime Converts Human Readable Date

 Keywords: udfStrpTime Converts Human Readable Date YYYY MM DD MM/DD/YYYY 

#DefineFunction udfStrpTime(date)
   ; Converts human readable date to MM/DD/YYYY format
   ErrorMode(@OFF)
   date=ObjectType("DATE",date)
   ErrorMode(@CANCEL)
   If LastError() == 1703
      Pause('Error','Invalid Date.')
      Return 0
   EndIf
   date=ItemExtract(2,date,":"):"/":ItemExtract(3,date,":"):"/":ItemExtract(1,date,":")
   Return date
#EndFunction

; Test 1
d = "Jan 01 2011"
result = udfStrpTime(d)
Message(d,result)

; Test 2
d = "January 01 2011"
result = udfStrpTime(d)
Message(d,result)

; Test 3
d = "Feb 30 2011" ; invalid date
result = udfStrpTime(d)
Message(d,result)
Exit

Article ID:   W18408

Filename:   udfStrpTime Converts Human Readable Date.txt

File Created: 2011:03:24:10:31:46

Last Updated: 2011:03:24:10:31:46