Convert month name to month number eg: December - 12

Lc1

New Member
Hi

How do i convert eg: 02 DECEMBER 2022 to 02.12.2022?
More specific, how to convert DECEMBER to number 12?
 

RReed

New Member
There's a few ways to go about it but most commonly used would be using the FormatDate logic within Blueprism to convert.

One potential way would be to do this:

FormatDate([Date],"dd")&"."&FormatDate([Date],"MM")&"."&FormatDate([Date],"yyyy")
 
Top