soapui assertion for timestamp format

Hi NadiaRanalli 

 

to pattern match a string in an assertion typically regex is used and for simple to even complex strings regex does the job perfectly

 

HOWEVER - pattern matching regex against datetimes is quite difficult as it's more difficult than you think to ensure the pattern you specify covers off all illegal dates in perpetuity.

 

The following stackoverflow link -->. https://stackoverflow.com/questions/1057716/regular-expression-to-validate-a-timestamp gives you some idea how complicated it can be to ensure you cover off all the illegals.

 

 

Via stackoverflow, Okipa came up with the following (gotta give credit where it's due! ;))

 

((((19|20)([2468][048]|[13579][26]|0[48])|2000)-02-29|((19|20)[0-9]{2}-(0[4678]|1[02])-(0[1-9]|[12][0-9]|30)|(19|20)[0-9]{2}-(0[1359]|11)-(0[1-9]|[12][0-9]|3[01])|(19|20)[0-9]{2}-02-(0[1-9]|1[0-9]|2[0-8])))\s([01][0-9]|2[0-3]):([012345][0-9]):([012345][0-9]))

 

I made a couple of tweaks to match your specific value so changed Okipa's regex to the following:

 

((((19|20)([2468][048]|[13579][26]|0[48])|2000)-02-29|((19|20)[0-9]{2}-(0[4678]|1[02])-(0[1-9]|[12][0-9]|30)|(19|20)[0-9]{2}-(0[1359]|11)-(0[1-9]|[12][0-9]|3[01])|(19|20)[0-9]{2}-02-(0[1-9]|1[0-9]|2[0-8])))T([01][0-9]|2[0-3]):([012345][0-9]):([012345][0-9]).[0-9]{3}Z)

 

Just to be clear - I didn't change much - Okipa did all the hard work and his regex validated the following value:

 

2021-10-04 14:38:03

 

I just altered it to include validation of the literal 'T' along with the fractional seconds and the UTC timezone indicator

 

2021-10-04T14:38:03.475Z

 

Cheers,

 

Rich