• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Incorrect Date Formatting

havengakm

Member
@Supreme please can you just provide some assistance on how I would write the formula to extract the day so I extract both days with "st" and "nd" in the same formula.
 

havengakm

Member
Because obviously I need to account for instances such as "1st"; "2nd" "3rd"; "4th" all within the one formula
 

Supreme

Well-known member
Staff member
Hey @havengakm

Please check out the following screenshot for your concern.

You can also refer to the following website to the given Regex.

https://stackoverflow.com/questions/6182290/regex-to-remove-ordinals

https://regexr.com/3cq3j

unnamed (1).png
 
Top