Unable to convert full 'DateTime' string into short 'Date' string

Help StudioX
,
1

hello to everyone,

I am sending a date variable from a backend microservice in the format java.util.Date 2024-05-21T00:00:00 and this is then received by the bot in the following format Tue May 21 2024 00:00:00 GMT+0200 (Central European Summer Time)

how can I simplify this variable so the bot can read it as dd.MM.yyyy

I tried doing the following - DateTime.ParseExact(StartDate, "ddd MMM dd yyyy HH:mm:ss 'GMT'zzz", System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy"))
and Iā€™m getting the error String was not recognized as a valid DateTime.

thanks in advance!

2

Hi @Dea_Pahumi

Try this

inputString="Tue May 21 2024 00:00:00 GMT+0200 (Central European Summer Time)"
DateTime.ParseExact(inputString, "ddd MMM dd yyyy HH:mm:ss 'GMT'K '(Central European Summer Time)'", System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

image
image918Ɨ322 14.2 KB

Regards,

3

Hi @Dea_Pahumi

Try this:

startDate = "Tue May 21 2024 00:00:00 GMT+0200 (Central European Summer Time)"

modifiedString = DateTime.ParseExact(startDate.Substring(0, startDate.IndexOf(" GMT")), "ddd MMM dd yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

image
image1158Ɨ632 27.7 KB

Hope it helps!!

4

So far this is not complete clear and maybe should be retaken, if needed

As the Timezone name is disturbing the parsing and also other parts are redundant, A regex Shortening can be tried:

grafik
grafik782Ɨ177 8.67 KB

[A-Za-z]+\s\d{2}\s\d{4}\s.+?(?=\s\()

So we can do:
grafik

And Parse:

grafik
grafik761Ɨ47 14.4 KB

But we recommend to als keep track of the offset and recommend to use the DateTimeOffset

grafik
grafik702Ɨ43 15.5 KB

Conversion into the desired format still can be done with toString

grafik
grafik822Ɨ43 17 KB

5

thank you all, all 3 solutions worked for me @lrtetala @Parvathy @ppr I appreciate your help :pray: