Date Format in Bridge

Hello,

I was trying to get date out from smartsheet to smartsheet bridge to do integration. However, when I see log file, the date is very different format and I cannot reformat the date using utility function:

The Appt Date, DOB and Start Date is all coming from date from Smartsheet, could someone help me on this?

Thank you!

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Amy Gan

Scroll down to the bottom of that list and you should see a "Customized Format" option:

Then you can specify the format you want:

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Amy Gan

Can you post a screen capture of your sheet in Grid View, showing the Column Properties for those date columns?

I'm unable to replicate what you're seeing when using Search Sheet and Date columns:

Thanks!

Genevieve

Amy Gan

Hi Genevieve,

My date is like this format. However, if I changed the column property just put date in text format, it works. But the backend log file showing some unreadable data. In the meanwhile, I would like to format the date to be MM/DD/YY but I did not see the format in bridge-format date. Is there a way that I can accomplish the goal?

Thanks

Genevieve P.

Hi @Amy Gan

I have to admit I am unsure why your dates are coming through as unreadable numbers and I'm not able to replicate it. However to get the data you'd like, we could add in a helper column:

Add in a Text-Number column and use the simple formula of

=[Start Date]@row

You can hide this in your sheet so it's not visible, but then Bridge will return the date value in the format you want (MM/DD/YY), since that's the text value that will be displayed in the helper column. Would that work for you?

Cheers,

Genevieve

Genevieve P.

Hey @Amy Gan

I've done a bit of digging and it looks to me like the date value that's coming back is the unix time, or the number of seconds since 1970-01-01T00:00:00Z.

Do you have the Numeric Dates checkbox checked?

Make sure this box is un-checked:

Let me know if that does the trick!

Cheers,

Genevieve

Samuel Mueller

@Amy Gan

I believe there is a checkbox for changing how the date appears. have you tried that?

Amy Gan

Hi Samuel and Genevieve,

Thank you! It works! However, I would like to change my date format into MM/DD/YY(like how it is in Smartsheet), I did not see the format date in bridge, could you help me on that?

Thank you!

Amy

Genevieve P.

Hi @Amy Gan

Scroll down to the bottom of that list and you should see a "Customized Format" option:

Then you can specify the format you want:

Cheers,

Genevieve

Amy Gan

Thank you Genevieve,

This problem is solved.

Joe Goetschel

Hi @Genevieve P. !! Any Idea why mine would be exporting like this?

{"formatted":"08/22/2023 11:49"}

What I am looking for is 08/22/2023 11:49 AM

2023-08-22 11_58_56-Designer - Bridge by Smartsheet and 1 more page - Work - Microsoft Edge.png

Here is my Update Row

2023-08-22 12_00_08-Designer - Bridge by Smartsheet and 1 more page - Work - Microsoft Edge.png

Genevieve P.

Hi @Joe Goetschel

Try grabbing the Date/Time value from the Run Log instead of from the module:

This should only grab the data after "Formatted:"

Let me know if that worked!

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.