String operations for date format to convert (01/2021 to 01/01/2021) and (1/1/2021 to 01/01/2021)

How do I update date when it is( 1/1/2021 to 01/01/2021 )and when it is in (01/2021 to 01/01/2021)

@Naresh_Mandava

Try as below

check as below

Hope this helps you
Thanks

Please find the below code, @Naresh_Mandava
CDate(“01/2021”).ToString(“dd/MM/yyyy”)
CDate(“1/1/2021”).ToString(“dd/MM/yyyy”)

Hope this may help you :slight_smile:

Thank you for the help @Manish540 and @Srini84

1 Like

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