# toText(date) format **URL:** \ **Category:** Get Help\ **Created:** [July 5, 2023, 2:15pm UTC](https://community.fibery.io/t/totext-date-format/4737 "2023-07-05T14:15:41Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![dukevannori](https://avatars.discourse-cdn.com/v4/letter/d/8c91f0/32.png) [@dukevannori](https://community.fibery.io/u/dukevannori)\ **Post date:** [July 5, 2023, 2:15pm UTC](https://community.fibery.io/t/totext-date-format/4737/1 "2023-07-05T14:15:41Z")
Hi, is there a way to easily add a format to an output of a date? for example something like this: ToText(Date, ‘YYYY-MM-dd HH:mm’) I use start-dates with time for meetings and want that in the name. what i do now is: ToText(Year(Date.Start())) + “-” + ToText(Month(Date.Start())) + “-” + ToText(Day(Date.Start())) + " - " + ToText(Hour(Date.Start())) + “-” + ToText(Minute(Date.Start())) but the output is not as expected as single digit days and month are just single digits and not converted to “01” from “1” for january for example any tip is welcome! 🙂 ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 5, 2023, 5:26pm UTC](https://community.fibery.io/t/totext-date-format/4737/2 "2023-07-05T17:26:41Z")
> [@dukevannori](#): > > is there a way to easily add a format to an output of a date? Not easily, sorry! But in general you can zero-pad by doing the following `Right("0“+ToText(Month(Date.Start())),2)` ---
**Author:** ![dukevannori](https://avatars.discourse-cdn.com/v4/letter/d/8c91f0/32.png) [@dukevannori](https://community.fibery.io/u/dukevannori)\ **Post date:** [July 5, 2023, 8:54pm UTC](https://community.fibery.io/t/totext-date-format/4737/3 "2023-07-05T20:54:47Z")
its really not the most simple solution, but better than nothing. now i have to dig through the doc about UTC … cause this is also something playing me here now) ---
**Author:** ![Mother\_Bones](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mother_bones/32/6927_2.png) [@Mother\_Bones](https://community.fibery.io/u/Mother_Bones)\ **Post date:** [July 6, 2023, 10:39pm UTC](https://community.fibery.io/t/totext-date-format/4737/4 "2023-07-06T22:39:40Z")
I read the docs on UTC but it’s not making sense in my situation. Everything seems 18 hours skewed but I’m only UTC -6. Besides which I imported a CSV with times in UTC. No conversion should’ve happened. But it did… If you’ve made any sense of it, please do share. Because I need to make sure I’m re-importing 18 datasets correctly when I do… ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 7, 2023, 7:08am UTC](https://community.fibery.io/t/totext-date-format/4737/5 "2023-07-07T07:08:22Z")
> [@Mother\_Bones](#): > > Everything seems 18 hours skewed but I’m only UTC -6 6 hours backward is the same as 18 hours forward. > [@Mother\_Bones](#): > > I imported a CSV with times in UTC If you use CSV import, Fibery will treat the dates as though they are in the timezone of the browser used during the import. > [@Mother\_Bones](#): > > No conversion should’ve happened. So if you import 09:15 it will assume that you mean 09:15 local time. > [@Mother\_Bones](#): > > Because I need to make sure I’m re-importing 18 datasets correctly when I do… If you just need to bulk correct a large dataset, create a temporary formula field which corrects any offset, then copy the results of the formula field into the original fields (easiest by using copy paste on a table view). Then you can delete the formula field