Date and Regex pattern format

Updated Apr 21, 2024 logs Applies to 10.0, 9.2
Download as PDF Contact support
Sl.No.RegxDate Pattern
1\d{4}-\d{2}-\d{1,2}T\d{1,2}:\d{2}:\d{2}.\d{3}+\d{4}yyyy-MM-dd'T'HH:mm:ss.SSSZ
2[A-Za-z]{3,}\s\d{1,2},\s\d{4},\s\d{1,2}:\d{2}:\d{2},\d{1,3}\s[A-Z]{2}\s[A-Z]{3}MMMMM dd, yyyy, hh:mm:ss,SSS a z
3[A-Za-z]{3}\s\d{1,2},\s\d{4},\s\d{1,2}:\d{2}:\d{2},\d{1,3}\s[A-Z]{2}\s[A-Z]{3}MMM dd, yyyy, hh:mm:ss,SSS a z
4[A-Za-z]{3,}\s[A-Za-z]{3,}\s\d{1,2}\s\d{1,2}:\d{2}:\d{2}\s[A-Za-z]{3,}\s\d{4}EEE MMM d HH:mm:ss z yyyy
5[A-Za-z]{3}\s[A-Za-z]{3}\s\d{1,2}\s\d{1,2}:\d{2}:\d{2}\s[A-Za-z]{3,}\s\d{4}EEE MMM d HH:mm:ss z yyyy
6\d{1,2}/\d{1,2}/\d{2}\s\d{1,2}:\d{2}:\d{2}:\d{1,3}\s[a-zA-Z]{3,}MM/dd/yy HH:mm:ss:SSS z
7\d{4}-\d{1,2}-\d{1,2}\s\d{1,2}:\d{2}:\d{2},\d{1,3}yyyy-MM-dd HH:mm:ss,SSS
8\d{4}-\d{1,2}-\d{1,2}\s\d{1,2}:\d{2}:\d{2}.\d{1,3}yyyy-MM-dd HH:mm:ss.SSS
9\d{1,2}/\d{1,2}/\d{2}\s\d{1,2}:\d{2}:\d{2}:\d{1,3}\s[A-Z]{3}MM/dd/yy HH:mm:ss:SSS z
10\d{1,2}/[A-Za-z]{3,}/\d{4}:\d{1,2}:\d{2}:\d{2}\s-\d{4}dd/MMMMM/yyyy:HH:mm:ss Z
11\d{1,2}/[A-Za-z]{3}/\d{4}:\d{1,2}:\d{2}:\d{2}\s-\d{4}dd/MMM/yyyy:HH:mm:ss Z
12\d{1,2}/\d{1,2}/\d{2}\s\d{1,2}:\d{2}:\d{2}:\d{1,3}MM/dd/yy HH:mm:ss:SSS
13\d{1,2}/\d{1,2}/\d{2}\s\d{1,2}:\d{2}:\d{2}MM/dd/yy HH:mm:ss
14\d{1,2}/[A-Za-z]{2,}/\d{4}:\d{1,2}:\d{2}:\d{2}dd/MMMM/yyyy:HH:mm:ss
15\d{14}yyyyMMddHHmmss
16\d{12}yyyyMMddHHmm
17\d{8}yyyyMMdd
18\d{8}\s\d{6}yyyyMMdd HHmmss
19\d{8}\s\d{4}yyyyMMdd HHmm
20\d{1,2}-\d{1,2}-\d{4}\s\d{1,2}:\d{2}:\d{2}dd-MM-yyyy HH:mm:ss
21\d{4}-\d{1,2}-\d{1,2}\s\d{1,2}:\d{2}:\d{2}yyyy-MM-dd HH:mm:ss
22\d{1,2}/\d{1,2}/\d{4}\s\d{1,2}:\d{2}:\d{2}MM/dd/yyyy HH:mm:ss
23\d{1,2}/\d{1,2}/\d{2}\s\d{1,2}:\d{2}:\d{2}MM/dd/yy HH:mm:ss
24\d{4}/\d{1,2}/\d{1,2}\s\d{1,2}:\d{2}:\d{2}yyyy/MM/dd HH:mm:ss
25\d{1,2}/\d{1,2}/\d{2}\s\d{1,2}:\d{2}:\d{2}dd/MM/yy HH:mm:ss
26\d{1,2}\s[a-z]{3}\s\d{4}\s\d{1,2}:\d{2}:\d{2}dd MMM yyyy HH:mm:ss
27\d{1,2}\s[a-z]{4,}\s\d{4}\s\d{1,2}:\d{2}:\d{2}dd MMMM yyyy HH:mm:ss
28\d{1,2}-\d{1,2}-\d{4}\s\d{1,2}:\d{2}dd-MM-yyyy HH:mm
29\d{4}-\d{1,2}-\d{1,2}\s\d{1,2}:\d{2}yyyy-MM-dd HH:mm
30\d{1,2}/\d{1,2}/\d{4}\s\d{1,2}:\d{2}MM/dd/yyyy HH:mm
31\d{4}/\d{1,2}/\d{1,2}\s\d{1,2}:\d{2}yyyy/MM/dd HH:mm
32\d{1,2}\s[a-z]{3}\s\d{4}\s\d{1,2}:\d{2}dd MMM yyyy HH:mm
33\d{1,2}\s[a-z]{4,}\s\d{4}\s\d{1,2}:\d{2}dd MMMM yyyy HH:mm
34\d{1,2}-\d{1,2}-\d{4}dd-MM-yyyy
35\d{4}-\d{1,2}-\d{1,2}yyyy-MM-dd
36\d{1,2}/\d{1,2}/\d{4}MM/dd/yyyy
37\d{4}/\d{1,2}/\d{1,2}yyyy/MM/dd
38\d{1,2}\s[a-z]{3}\s\d{4}dd MMM yyyy
39\d{1,2}\s[a-z]{4,}\s\d{4}dd MMMM yyyy

Was this article helpful?

Votes and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.

Vote on this articleFollow for updates

Opens Zendesk · needs internet and sign-in

Articles in this section: Applications

Related articles

Still stuck? Contact support