# Convert Datetime to YYYYMMDD issue: day is incorrect

**URL:** <https://forums.pega.com/t/convert-datetime-to-yyyymmdd-issue-day-is-incorrect/4108>\
**Category:** User Experience\
**Tags:** 8-6-6, user-experience\
**Created:** [March 6, 2023, 2:12pm UTC](https://forums.pega.com/t/convert-datetime-to-yyyymmdd-issue-day-is-incorrect/4108 "2023-03-06T14:12:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MaxonL16591286](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@MaxonL16591286](https://forums.pega.com/u/MaxonL16591286)\
**Post date:** [March 6, 2023, 2:12pm UTC](https://forums.pega.com/t/convert-datetime-to-yyyymmdd-issue-day-is-incorrect/4108/1 "2023-03-06T14:12:24Z")

</div>

.SelectedDeadlineDateTime is in type DateTime

I use this function to convert it to YYYYMMDD,

@(Pega-RULES:DateTime).FormatDateTime(.SelectedDeadlineDateTime,“YYYYMMDD”,null,null)

However, it returns incorrect DD once the date after 31Jan, e.g. as below sample. It should be a julian date. I expect 20230201. May I know how could I get this date string? thanks.

 ![image.png](https://pega1.discourse-cdn.com/pega/original/2X/1/1fc605882db62628b50f1228ec3f54c3ce8866d7.png)

---

<div class="post-metadata">

**Author:** ![MaxonL16591286](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@MaxonL16591286](https://forums.pega.com/u/MaxonL16591286)\
**Post date:** [March 6, 2023, 2:20pm UTC](https://forums.pega.com/t/convert-datetime-to-yyyymmdd-issue-day-is-incorrect/4108/2 "2023-03-06T14:20:22Z")

</div>

@MaxonL16591286 Hi I tried YYYYMMdd is fine, thanks.

Any better solution, pls advise.

---

<div class="post-metadata">

**Author:** ![Anoop\_Krishna](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/anoop_krishna/32/23458_2.png) [@Anoop\_Krishna](https://forums.pega.com/u/Anoop_Krishna)\
**Post date:** [March 6, 2023, 2:25pm UTC](https://forums.pega.com/t/convert-datetime-to-yyyymmdd-issue-day-is-incorrect/4108/3 "2023-03-06T14:25:31Z")

</div>

@MaxonL16591286 If this is just for display purpose, then you can use substring function and form your date accordingly and then use that string to display.

---

<div class="post-metadata">

**Author:** ![mrits1](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/mrits1/32/12113_2.png) [@mrits1](https://forums.pega.com/u/mrits1)\
**Post date:** [March 6, 2023, 4:01pm UTC](https://forums.pega.com/t/convert-datetime-to-yyyymmdd-issue-day-is-incorrect/4108/4 "2023-03-06T16:01:49Z")

</div>

@MaxonL16591286 Hi, Can you please try the below function?

@DateTime.FormatDateTime(@DateTime.CurrentDateTime(),“yyyyMMdd”,“”,“”)

Please add timezone and Locale according to your requirement.

 ![DT.png](https://pega1.discourse-cdn.com/pega/original/3X/f/a/fa20b9f28cf5180b74029b5856a3ad889aa16f0c.png)
