Date conversion - help

Help StudioX
, , , , , ,
1

Hi, can anyone tell me how i convert this MAR-20-2021 pattern into 20210320

2

@Anjali_Rani - Are you going to try in StudioX or Studio?? if its Studio…Please change your question category to Studio…

3

Hi Anjali,

User this expression :

datetime.parseexact(datestring,“MMM-dd-yyyy”,system.globalization.culturalinfo.invariantculture).tostring(“yyyyMMdd”)

Let me know in case of any question.

Regards,
Sahil

4

@Anjali_Rani

image

5

ok sure.

6

Thank You so much.

7

@Anjali_Rani - This would also do…shorter version…

CDate(“MAR-20-2021”).ToString(“yyyyMMdd”)

8

Thankyou.

9

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