DateTime conversion

Help Activities
, ,
1

I Want to convert this “05SEP” String into “dd-MM-yyyy” format that is 05-09-2021(Current year) how to do it??? Help me

Forum Engagement Daily Reports
2

@Gopi_Krishna1

Try this.

  CDate("05SEP").ToString("dd-MM-yyyy")
3

grafik
grafik

CDate("05SEP"&"2021").toString("dd-MM-yyyy")
CDate(YourStringVar & "2021").toString("dd-MM-yyyy")

kindly note:
grafik
will return not the mentioned one date 5th sep 2021

4

I am having this “05SEP” string value in a variable shall use variable in this expression

5

@Gopi_Krishna1

Use solution provided by @ppr

We need to append the year with date.

6

I want to dynamic year, If next year comes means I would mention 2022, is their any expression to mention the currrent year

7

grafik

8

@Gopi_Krishna1

Try below expression.
CDate(“05SEP”&Now.Year.ToString).ToString(“dd-MM-yyyy”)

9

Screenshot 2021-10-18 161641
Screenshot 2021-10-18 161641938×451 24.3 KB

10

just end the word year with the r in your code

11

Screenshot 2021-10-18 161907

12

Screenshot 2021-10-18 162427
Screenshot 2021-10-18 1624271067×213 10.8 KB

13

what modification I have to do it in this expression

14

@Gopi_Krishna1

It should be like this.

  CDate(Extracted_Estimated_Date&Now.Year.ToString).ToString("dd-MM-yyyy")

Here, Extracted_Estimated_Date variable of type String and it holds the Date and Month.

15

Screenshot 2021-10-18 163034
Screenshot 2021-10-18 163034718×328 3.9 KB

16

Showing error, ‘(’ expected showing like this

17

@Gopi_Krishna1

Put dot . after year. It should be like this Now.Year.ToString

19

CDate(Extracted_Estimated_Date&Now.Year.ToString).ToString(“dd-MM-yyyy”)
Like this only I have mentioned

20

Screenshot 2021-10-18 164349
Screenshot 2021-10-18 164349935×208 10.5 KB

What is the exact modification that I have to do shown by notification Please do explain it bro

21

Thanks Bro Have Got the Expected Output