Custom date format regular expression

Hi @Prineel_V3 

This is doable…

Step 01: Format date to String. 

Format: YYYY-MM-DD HH:mm:ss 
Output: txt_CurrentDate

Step 02: Apply Regex to extract Date  

Input: txt_CurrentDate  (Output from Step 1)

Replace

Pattern: (\d{4})-(\d{2})-(\d{2})(.*)

Replacement: $2/$3/$1

Output: txt_FormatDate

Step 03: Apply Regex to extract Time  

Input: txt_CurrentDate  (Output from Step 1)

Replace

Pattern: (\d{4})-(\d{2})-(\d{2})(.*)

Replacement: $4

Output: txt_FormatTime

Step 04: Apply Regex to extract Hour  

Input: txt_FormatTime  (Output from Step 3)

Replace

Pattern: (\d{2}):(\d{2}):(\d{2})

Replacement: $1

Output: txt_Hours

Step 05: Convert txt Hours into Integer  

Input: txt_Hours  (Output from Step 4)

Output: int_Hours

Step 06

Check if Hours equals 00

Check if Hours equal 12

Check if Hours less than 12

BRANCH If int_Hours == 0

Step 06a: Apply Regex   

Input: txt_FormatTime  (Output from Step 3)

Replace

Pattern: (\d{2}):(\d{2}):(\d{2})

Replacement: 12:$2 AM

Output: txt_FormatTime 

Explanation: If the time is 00:00:01 or 00:30:20, we are going to format it as 12:00 AM or 12:30 AM

BRANCH If int_Hours == 12

Step 06b: Apply Regex   

Input: txt_FormatTime  (Output from Step 3)

Replace

Pattern: (\d{2}):(\d{2}):(\d{2})

Replacement: 12:$2 PM

Output: txt_FormatTime 

Explanation: If the time is 12:00:01 or 12:30:20, we are going to format it as 12:00 PM or 12:30 PM

BRANCH If int_Hours < 12

Step 06c: Apply Regex   

Input: txt_FormatTime  (Output from Step 3)

Replace

Pattern: (\d{2}):(\d{2}):(\d{2})

Replacement: int_hour:$2 AM

Output: txt_FormatTime 

Explanation: Get hours and minutes, append AM

BRANCH If int_Hours < 12  (The NO branch)

Additional Step → Minus 12 from int_Hours

Step 06d: Apply Regex   

Input: txt_FormatTime  (Output from Step 3)

Replace

Pattern: (\d{2}):(\d{2}):(\d{2})

Replacement: int_hour:$2 PM

Output: txt_FormatTime 

Explanation: Get hours and minutes, append PM

TESTING RESULT

I used a Datetime control for input instead of getting the actual Datetime from Context 

Hope that helps

If you haven’t voted for it already, there’s an idea out there to add more options to the Format Date to String action. 

https://ideas.nintex.com/ideas/IDEA-I-2639