topic Re: Unable to Split Month Name from Date Format 07/15/2017 in University Forum

Unable to Split Month Name from Date Format 07/15/2017

Adnan3194 — Mon, 23 Dec 2024 14:08:16 GMT

dear BP Community members.

i am learning Blueprism, i am trying to webbased application, i want to split MONTH name only from Date (format date is 07/15/2017), please guide how to get Month Name only from this date format and what will be use for expression.? thank you

Re: Unable to Split Month Name from Date Format 07/15/2017

michaeloneil — Mon, 23 Dec 2024 14:33:54 GMT

Hi @Adnan3194

If you add a calculation stage to your process and include the following FormatDate("07/15/2017","MMM") this should output the value as "Jul". If you want the full month name then you just increase the number of Ms in the format e.g. FormatDate("12/15/2017","MMMMMMMM") will show "December"

Re: Unable to Split Month Name from Date Format 07/15/2017

Adnan3194 — Mon, 23 Dec 2024 14:38:05 GMT

but how to Get Only Month name from date expression? Mean if i get date (21 December 2024), Now i want just Month Name. how i will get only Month name?

Re: Unable to Split Month Name from Date Format 07/15/2017

Mohamad_Dakkouri — Mon, 23 Dec 2024 14:55:48 GMT

Try this :

FormatDate(ToDate("21 December 2024"),"MMMMMMMM")

Re: Unable to Split Month Name from Date Format 07/15/2017

Adnan3194 — Mon, 23 Dec 2024 15:16:39 GMT

hi.. please guide how i get flags of these classes (Economy, First and Business Class) data will be pick from Item Data Collection [ITEM DATA.SERVICE CLASS]

how i will use expression that one will be mark one True and other mark false

Re: Unable to Split Month Name from Date Format 07/15/2017

Mohamad_Dakkouri — Tue, 24 Dec 2024 07:16:46 GMT

You should have just one input text data item something like [Service Class]

And then you can use the logic in multi choice criteria

Lower([Service Class])="economy class"

Lower([Service Class])= "business class"

Lower([Service Class])="first class"

You see what i mean ?

Re: Unable to Split Month Name from Date Format 07/15/2017

Adnan3194 — Wed, 25 Dec 2024 10:01:46 GMT

thank you for your support