I want change string format 20201130 to date format 2020/11/30, can any one help me on this?

Help Studio
, ,
1

I want change string format 20201130 to date format 2020/11/30, can any one help me on this?
@Palaniyappan

2

Hi! Welcome to community!

Try Like this:

Assign DateVar = Datetime.ParseExact(Output.ToString, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy/MM/dd")

Reference:

Date1
Date11512×414 16.7 KB

Regards,
NaNi

3

Datetime.ParseExact(“20201130”,“yyyyMMdd”,System.Globalization.Cultureinfo.invariantculture).Tostring(“yyyy/MM/dd”)

4

hi,
Solved, thank you
@THIRU_NANI @Gangadhar_Athili

5

Hey!

Both queries are same!

Here we’re using the Variable instead of hardcoding

if you’ve bulk data this will works fine

Regards,
NaNi

6

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