text
MM/dd/yyyy
DateTime_Out
Convert text From:
MM/dd/yyyy
REGEX_Match([text], '^\d\/\d\d\/\d\d\d\d') or REGEX_Match([text], '^\d\d\/\d\d\/\d\d\d\d') or
REGEX_Match([text], '^\d\/\d\/\d\d\d\d') or REGEX_Match([text], '^\d\d\/\d\/\d\d\d\d')
Custom
dd/mm/yyyy
REGEX_Match([text], '^\d\/\d\d\/\d\d\d\d') or REGEX_Match([te...
Replace periods and dashes with slashes and remove hr:mi:ss
orig_text=[text]
text=regex_replace(replace( Replace( [text], '-','/'),'.', '/...
Simple
DateTime_Out
IsNull
IsNull([DateTime_Out])
text
dd/MM/yyyy
DateTime_Out
Convert text From:
dd/MM/yyyy
REGEX_Match([text], '^\d\/\d\d\/\d\d') or
REGEX_Match([text], '^\d\d\/\d\d\/\d\d') or
REGEX_Match([text], '^\d\/\d\/\d\d') or
REGEX_Match([text], '^\d\d\/\d\/\d\d')
Custom
dd/mm/yy
REGEX_Match([text], '^\d\/\d\d\/\d\d') or
REGEX_Match([text]...
text
MM/dd/yy
DateTime_Out
Convert text From:
MM/dd/yy
Simple
DateTime_Out
IsNull
IsNull([DateTime_Out])
text
dd/MM/yy
DateTime_Out
Convert text From:
dd/MM/yy
Warning
All
ByName
REGEX_Match([text], '^\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/\d\d') or
REGEX_Match([text], '^\d\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/\d\d')
Custom
dd/MON/yy
REGEX_Match([text], '^\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/...
text
d/-Mon.-yy
DateTime_Out
Convert text From:
d/-Mon.-yy
REGEX_Match([text], '^\d\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/\d\d')
Custom
dd/MON/yy
REGEX_Match([text], '^\d\d\/[[:alpha:]][[:alpha:]][[:alpha:]]...
text='0'+[text]
Warning
All
ByName
REGEX_Match([text], '^\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/\d\d\d\d') or
REGEX_Match([text], '^\d\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/\d\d\d\d')
Custom
dd/MON/yyyy
REGEX_Match([text], '^\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/...
REGEX_Match([text], '^\d\d\/[[:alpha:]][[:alpha:]][[:alpha:]]\/\d\d\d\d')
Custom
dd/MON/yyyy
REGEX_Match([text], '^\d\d\/[[:alpha:]][[:alpha:]][[:alpha:]]...
text='0'+left([text], length([text])-4)+right([text], 2)
text=left([text], length([text])-4)+right([text], 2)
DateTime_Out=[DateTime_Out2]
DateTime_Out=[DateTime_Out2]
REGEX_Match([text], '^[[:alpha:]]+day\,.*$')
Custom
Day, dd Month yyyy
REGEX_Match([text], '^[[:alpha:]]+day\,.*$')
text
day, dd Month, yyyy
DateTime_Out
Convert text From:
day, dd Month, yyyy
Swap space for a comma
text=left([text], length([text])-5)+', '+right([text], 4)
mon
monday
tue
tuesday
wed
wednesday
thu
thursday
thur
thursday
fri
friday
sat
saturday
sun
sunday
jan
january
feb
february
mar
march
apr
april
may
may
jun
june
jul
july
aug
august
sep
september
oct
october
nov
november
dec
december
Error
contains([text], [day], 1)
Custom
contains([text], [day], 1)
text=Replace(lowercase([text]), [day]+'.', [day_abbr])
Warning
All
ByName
match=if contains([text], [day], 1) then 1 else 0 endif
Error
match=if contains(lowercase([text]), [mon_abbr], 1) then 1 el...
Custom
contains(lowercase([text]), [mon_abbr]+' ', 1) or
contains(l...
text=Replace(lowercase([text]), [mon_abbr], [month])
Warning
All
ByName
text
Replace
text
Warn
text_Matched
Replace:
(.*\s)(\d)(\s.*)
$1 0$2$3
Simple
DateTime_Out
IsNull
IsNull([DateTime_Out])
text
Replace
text
Warn
text_Matched
Replace:
(.*\s)(\d)(\,.*)
$1 0$2$3
text
Replace
text
Warn
text_Matched
Replace:
(.*\,\s)([[:alpha:]]*)(\s*)...
$1$4 $2$5$6
text
day, dd Month, yyyy
DateTime_Out
Convert text From:
day, dd Month, yyyy
REGEX_Match([text], '^\d\d\d\d\d\d\d\d$')
Custom
YYYYMMDD
REGEX_Match([text], '^\d\d\d\d\d\d\d\d$')
text
yyyyMMdd
DateTime_Out
Convert text From:
yyyyMMdd
REGEX_Match(trim([text]), '^[[:alpha:]]*\s\d*\,\s\d*$')
Custom
Month dd, yyyy
REGEX_Match(trim([text]), '^[[:alpha:]]*\s\d*\,\s\d*$')
text
Replace
text
Warn
text_Matched
Replace:
(.*\s)(\d)(\s.*)
$1 0$2$3
text
Replace
text
Warn
text_Matched
Replace:
(.*\s)(\d)(\,.*)
$1 0$2$3
text
Month dd, yyyy
DateTime_Out
Convert text From:
Month dd, yyyy
Simple
DateTime_Out
IsNull
IsNull([DateTime_Out])
Make Year 4 Digit
text=left([text], length([text])-2) +
if tonumber(right([text...
text
Month dd, yyyy
DateTime_Out
Convert text From:
Month dd, yyyy
DateTime_Out='1900-01-01'
DateTime_Out=[DateTime_Out2]
Input82
1/JAN/15
1-JAN-15
15/JAn/15
15-Jan-15
1/JAN/2015
1-JAN-2015
15/JAn/2015
15-Jan-2015
Tuesday, 01 January 2015
Tuesday, 1 January 2015
Tuesday, 15 January 2015
Tuesday, 15 Jan 2015
1/01/15
1-1-15
15/01/15
15-01-15
1/1/2015
1-1-15
15/01/2015
15-01-2015
Tuesday, January 01 2015
Tuesday, January 1 2015
Tuesday, January 15 2015
Tuesday, Jan 15 2015
15/01/15 14:12:12
15/01/2015 14:12:12
January 01, 2015
January 1, 2015
January 15, 2015
January 01, 15
January 1, 15
January 15, 15
15-01-15 14:12:12
15-01-2015 14:12:12
1-01-15 14:12:12
1-01-2015 14:12:12
15.01.15 14:12:12
15.01.2015 14:12:12
1.01.15 14:12:12
1.01.2015 14:12:12
1.JAN.15
15.JAn.15
1.JAN.2015
15.JAn.2015
1.01.15
15.01.15
1.1.2015
15.01.2015
20150115
20150101
Nov 16, 2015
16-NOV-2015
6-Jan-05
2015-04-27
2015-4-27
2015/04/27
2015/4/27
2015/4/8
2015-4-8
Output84
text
yyyy-MM-dd
DateTime_Out
Convert text From:
yyyy-MM-dd
text=replace([text], '/', '-')
Simple
DateTime_Out
IsNull
IsNull([DateTime_Out])
Horizontal
Question
Macro Input (82)
Question
Macro Output (84)
Auto Convert Any Date
Tab
Questions
Tab (81)
MacroInput
Macro Input (82)
Macro Input (82)
MacroOutput
Macro Output (84)
Macro Output (84)
Macro