# Date Format in Glide Differs from Google Sheet **URL:** \ **Category:** Ask for Help\ **Created:** [December 5, 2022, 5:19pm UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436 "2022-12-05T17:19:54Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 5, 2022, 5:19pm UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/1 "2022-12-05T17:19:54Z")
Dear Community We have created a column date column in Google Sheet (GS), with the following format. This column format is similar to the rest of the date column in the GS ![Google Sheet Value](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/37e3f8588f6b1f3c788ab2715022184d523896ff.jpeg) Format ![Google Sheet Date Format](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/32a5b0fe4a2c1ff956b452fc5a6378e5ee552e69.jpeg) However in Glide this is the only column that is different from all the rest of the columns ![Date Format in Glide is Different](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/ed667f90c5dee9f7acabb1f110b5eebf300aa827.jpeg) ![Date Format in Glide is Different 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/324b0a704d053221f2eaf7237926be9f17ba94eb.jpeg) Looking forward to any advise? Appreciate in advance! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 5, 2022, 5:55pm UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/2 "2022-12-05T17:55:38Z")
Once you edit a Date type column in glide, it’s going to apply formatting based on the preset date formats in the column configuration. That format is for display purposes in the app. The underlying value is still the same as what’s in the sheet. If you don’t want glide to apply date formatting, then you can change the column type to Text, and it will show the underlying value. However, what you want seems very similar to the ‘Short’ date format that is provided in glide. I usually try to avoid applying any formatting within a google sheet if I can avoid it. ---
**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\ **Post date:** [December 5, 2022, 7:38pm UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/3 "2022-12-05T19:38:19Z")
Ya, I think you could just use the short date option would looks like this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cdc6351383958cc10a64245cad37aef35b7f790.png) ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 6, 2022, 1:28am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/4 "2022-12-06T01:28:44Z")
Thanks for your prompt reply! Appreciate ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/994998a47a49315a6c6ce5196413426392a0068a.jpeg) How can i format the date to appear the required i.e 6 Dec 2022 instead of the current? ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 6, 2022, 1:30am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/5 "2022-12-06T01:30:01Z")
Thanks for your prompt reply! Appreciate. Seems like the short date may not be correct as well. The date which i have filled from 3rd party app to GS is 6 Dec 2022. 😅 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 6, 2022, 1:37am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/6 "2022-12-06T01:37:25Z")
> [@ichilddev](#): > > Seems like the short date may not be correct as well. “correct” is in the eye of the beholder. What I mean by that is that it really doesn’t matter how you format your datetime values, because every user device will reformat them according to its own settings. For example, if a user in the USA opens your App, they will most likely see dates in mm-dd-yyyy format, regardless of how you think you’ve formatted them. If you really want to “force” your users to see a specific date format, then the only way to do that is to convert all your datetime values to strings. But if you do that, you lose the ability to do datetime math or datetime comparisons. Also, it’s rude. So don’t do it. Also, how you format your datetime values in your Google Sheet is irrelevant to Glide. Glide will sync your data - not your formatting. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 6, 2022, 1:40am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/7 "2022-12-06T01:40:53Z")
You may want to check your browser, computer, and Google sheet settings. Seems that you maybe have the region/locale set to US format instead of…ahem…what the rest of the world uses. Best not to muck with formatting on google sheets. It just causes problems. ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 6, 2022, 8:07am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/8 "2022-12-06T08:07:26Z")
Hi hi Wondering why there is a ’ when the column is a Format Date column? ![Format Date from User Key IN 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4ea912c800ede37b31467b33e4f8dc43b5af05a2.jpeg) This format seems similar to GS’s, which can be seen in our first post. This is the value found in GS ![Format Date from User Key IN](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d24e829e042eb1fc90e2c01ad5b679ea7efaf8ee.jpeg) We need to format the column accordance to the GS’s column, else the value will not be triggered. If we update the GS directly, the column in GS will be triggered at the date/time registered. Currently, data from Glide does not effect the trigger. Looking for expert to help on this. Appreciate for any response. ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 6, 2022, 9:43am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/9 "2022-12-06T09:43:25Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4dc2d60e6243df24ef9cb0f5b1b30390ba99683f.png) Any advise how can i set column without have this ’ at the beginning of the cell value: '06-12-2022 18:00:00 Without the ’ , the process works. How do i change to text from date? Appreciate any advise. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 6, 2022, 10:42am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/10 "2022-12-06T10:42:08Z")
> [@ichilddev](#): > > Wondering why there is a ’ when the column is a Format Date column? Because it’s no longer a date. It’s text that looks like a date. If you need the date formatting applied in the Google Sheet, send a date value from Glide, and then apply the formatting afterwards. ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 6, 2022, 12:17pm UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/11 "2022-12-06T12:17:18Z")
> [@ichilddev](#): > > ![Format Date from User Key IN 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4ea912c800ede37b31467b33e4f8dc43b5af05a2.jpeg) > > This format seems similar to GS’s, which can be seen in our first post. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/647509db218e39a30ede2cac4dd4850dc8a9510d.jpeg) Over here I have formatted the date in the format required by Google sheet. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d132d92c838aa42c805f676c857f78341bb3745.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 6, 2022, 12:30pm UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/12 "2022-12-06T12:30:46Z")
The Format Date plugin converts your Date to a string. Yes, it still _looks_ like a date, but it isn’t. It’s text. > [@Darren\_Murphy](#): > > If you need the date formatting applied in the Google Sheet, send a date value from Glide, and then apply the formatting afterwards. ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 9, 2022, 7:25am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/13 "2022-12-09T07:25:13Z")
hi @Darren_Murphy Darren, We have the following date format in GS: ![Date Format in GS](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e04c77a9477d6a05d5afb7c27bd5f1dc054e82f1.png) And in Glide, the format as such: ![Date Format In Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/53664e09ddaae106063678ec1d9880c1606cab05.png) It seems that the date that is parsed to Google Sheet from Glide does not effect the trigger. This is the date format received from Pabbly via Webhook via Google Sheet ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/ef517b6a08b42bf8a79e0b230368702f55322dbf.png) Is there any way we can set the date/time format explicitly in Glide as per shown above? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 9, 2022, 7:50am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/14 "2022-12-09T07:50:14Z")
> [@ichilddev](#): > > It seems that the date that is parsed to Google Sheet from Glide does not effect the trigger. What do you actually mean by that? The trigger doesn’t fire? It fires, but generates an error? Something else? > [@ichilddev](#): > > Is there any way we can set the date/time format explicitly in Glide as per shown above? Well, you can use the Date Format plugin like you were before to force the format, but as I pointed out earlier, that converts it to a string. So you’d probably have to do some post-processing in the Google Sheet to convert it back to a date. I’m not familiar with Pabbly, but I would have thought that if you pass it a valid datetime value, then the format should be irrelevant? 🤷‍♂️ ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [December 9, 2022, 8:36am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/15 "2022-12-09T08:36:59Z")
> [@Darren\_Murphy](#): > > What do you actually mean by that? > The trigger doesn’t fire? > It fires, but generates an error? > Something else? The Trigger doesn’t fire. No error at all. It trigger only if i have updated the GS directly. So does it mean it is Glide issue, or Pabbly issue. We have checked [Make.com](http://Make.com). It does not update row, thus would not be useful. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 9, 2022, 8:41am UTC](https://community.glideapps.com/t/date-format-in-glide-differs-from-google-sheet/55436/16 "2022-12-09T08:41:15Z")
> [@ichilddev](#): > > The Trigger doesn’t fire. No error at all. My guess is that it might be looking for the wrong type of event. When Glide adds or updates a row in your Google Sheet, that triggers an `Update` event. When you edit the sheet manually, that’s considered an `Edit` event. This might be why it only triggers when you edit the sheet manually.