# Date format check for Japanese

**URL:** <https://forum.xbench.net/t/date-format-check-for-japanese/874>\
**Category:** Technical Support\
**Created:** [February 15, 2022, 9:27pm UTC](https://forum.xbench.net/t/date-format-check-for-japanese/874 "2022-02-15T21:27:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yoko](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/yoko/32/358_2.png) [@Yoko](https://forum.xbench.net/u/Yoko)\
**Post date:** [February 15, 2022, 9:27pm UTC](https://forum.xbench.net/t/date-format-check-for-japanese/874/1 "2022-02-15T21:27:17Z")

</div>

Hello @omartin,

I’m trying to check the following case:

If the source is “2/15/2022 2:00:00 PM UTC”, the target needs to be “2022 年 2 月 15 日午後 2 時 (UTC)”

In this case, how can I specify?

Thank you!

---

<div class="post-metadata">

**Author:** ![omartin](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/omartin/32/82_2.png) [@omartin](https://forum.xbench.net/u/omartin)\
**Post date:** [February 16, 2022, 9:23am UTC](https://forum.xbench.net/t/date-format-check-for-japanese/874/2 "2022-02-16T09:23:35Z")

</div>

@Yoko, this search should suit your needs:

Source: `"<[0-9]{,2})=1\/[0-9]{,2})=2\/[0-9]{4})=3 [0-9]{,2})=4\:00\:00 PM UTC"`  
Target: `-"<@3 年 @1 月 @2 日午後 @4 時 \(UTC\)”`

Search mode: regular expressions  
PowerSearch: On

---

<div class="post-metadata">

**Author:** ![Yoko](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/yoko/32/358_2.png) [@Yoko](https://forum.xbench.net/u/Yoko)\
**Post date:** [February 16, 2022, 10:08am UTC](https://forum.xbench.net/t/date-format-check-for-japanese/874/3 "2022-02-16T10:08:28Z")

</div>

> [@omartin](#):
>
> -"\<@3 年 @1 月 @2 日午後 @4 時 (UTC)”

Hi @omartin , thank you!  
I tried your search but I get the following error.

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/xbench/original/1X/e0cebe8969a02f119f8422307dedcf8a3add36b5.png)

Am I doing something wrong?

Thank you!

---

<div class="post-metadata">

**Author:** ![omartin](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/omartin/32/82_2.png) [@omartin](https://forum.xbench.net/u/omartin)\
**Post date:** [February 16, 2022, 11:15am UTC](https://forum.xbench.net/t/date-format-check-for-japanese/874/4 "2022-02-16T11:15:34Z")

</div>

There was a typo error. Use the following one with the same options:

Source: `"<([0-9]{,2})=1\/([0-9]{,2})=2\/([0-9]{4})=3 ([0-9]{,2})=4\:00\:00 PM UTC"`  
Target: `-"<@3 年 @1 月 @2 日午後 @4 時 \(UTC\)"`

---

<div class="post-metadata">

**Author:** ![Yoko](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/yoko/32/358_2.png) [@Yoko](https://forum.xbench.net/u/Yoko)\
**Post date:** [February 17, 2022, 7:21am UTC](https://forum.xbench.net/t/date-format-check-for-japanese/874/5 "2022-02-17T07:21:07Z")

</div>

Hi @omartin thank you so much, but I’m still not getting expected results. I’ll review the condition and get back to you. Thanks!