# Date Format mm/dd/yyyy

**URL:** <https://www.ruby-forum.com/t/date-format-mm-dd-yyyy/262631>\
**Category:** Development\
**Created:** [March 21, 2022, 11:37pm UTC](https://www.ruby-forum.com/t/date-format-mm-dd-yyyy/262631 "2022-03-21T23:37:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rubenube](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/5daacb/32.png) [@rubenube](https://www.ruby-forum.com/u/rubenube)\
**Post date:** [March 21, 2022, 11:37pm UTC](https://www.ruby-forum.com/t/date-format-mm-dd-yyyy/262631/1 "2022-03-21T23:37:53Z")

</div>

Hello, we have a Ruby script and are having problems with the date format. The required format is mm/dd/yyyy. The result is mm dd yyyy. The slashes are missing.

Here are the 2 lines in the script:  
FORMAT(bhdb\_bill\_dt1, ‘MM/dd/yyyy’) AS Statement\_Date,  
FORMAT(bhdb\_due\_dt1, ‘MM/dd/yyyy’) AS Due\_Date

For example the result should be 03/21/2022, but we are getting 03 21 2022

We are using Ruby version 2.6.5p114

Appreciate any help you can offer!

---

<div class="post-metadata">

**Author:** ![infinity\_universe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/82dd89/32.png) [@infinity\_universe](https://www.ruby-forum.com/u/infinity_universe)\
**Post date:** [April 23, 2022, 10:01am UTC](https://www.ruby-forum.com/t/date-format-mm-dd-yyyy/262631/2 "2022-04-23T10:01:50Z")

</div>

Hi rubenube!  
In case you’re returning a DateTime object, you can do something like:

```auto
your_variable.strftime("%Y/%m/%d ")

```

Anyways, the syntax you’re sharing above looks like SQL. Could you provide more details of your script?  
Thanks