Convert to String to datetime

Help Studio
, ,
1

Hi,

I have string “20240524” (yyyy-MM-DD) i want to compare it with current date,so I want to convert it 05-24-2024, Any leads

2 
DateTime.ParseExact("20240524", "yyyyMMdd", System.Globalization.CulturInfo.InvariantCulture).ToString("MM-dd-yyyy")
3

But keep in mind, that we do compares on DateTime Base and will not recommend doing it on string base

e.g.

DateTime.ParseExact("20240524", "yyyyMMdd", System.Globalization.CulturInfo.InvariantCulture).Date < Now.Date

UPD1 - sample

4

Hi @quick_123

Assign -> inputString = "20240524"
Assign -> output = DateTime.ParseExact(inputString,"yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("MM-dd-yyyy")

image
image920×545 68 KB

Note: If you want to convert date of one format to another format it dataType would be System.String only.

For Comparision, you can follow below syntax:

inputString = "20240524"

If
   DateTime.ParseExact(inputString,"yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).Date < Now.Date
Then
    Assign -> output = DateTime.ParseExact(inputString,"yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("MM-dd-yyyy")
    Write Line -> output
Else
   Do required process
End If

Let me know if you have any queries

Regards

5

20240524 is not yyyy-MM-DD it’s yyyyMMdd.

You don’t convert it to 05-24-2024, that’s a string. You convert it to a datetime to compare with another datetime. Datetimes do not have a format, they store a value. You can format that value however you want, when you convert it to string.

To convert to datetime:

DateTime.ParseExact("20240524","yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture)

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.