What does the heart emoji sent by user U05A7KLNALC mean?

Help
21

lastly

22

notion_create_page_from_database

23

for the date and time property: {{steps.format_iso8601_datetime.$return_value.date_time}}

24

let me know if you need any other info from me

25

Thank you for providing the details of your workflow. Based on the information you’ve shared, I understand that you’re using the “New Row Added (Instant) from Google Sheets” trigger, followed by the format_iso8601_datetime step, and finally the “notion_create_page_from_database” action with the Date & Time property set to {{steps.format_iso8601_datetime.$return_value.date_time}}. To better understand the issue with the date format, could you please share the code you’ve used in the format_iso8601_datetime step? This will help me identify if there’s any issue with the date conversion process.

26

yes!

format_iso8601_datetime_1

CONFIGURE

format_iso8601_datetime

CONFIGURE

ISO 8601 Date/Time

{{steps.trigger.event.newRow[2]}}

RESULTS

Success
Reference exports in future steps via the steps object

steps.format_iso8601_datetime{1}
$return_value{3}
date_time:
08/10/2023 7:00:00 pm
date:
08/10/2023
time:
7:00:00 pm

27

Deprecation warning: value provided is not in a recognized RFC2822 or ISO format. moment construction falls back to js Date(), which is not reliable across all browsers and versions. Non RFC2822/ISO date formats are discouraged. Please refer to Moment.js | Guides for more info.
Arguments:
[0] _isAMomentObject: true, _isUTC: false, _useUTC: false, _l: undefined, _i: 8/10/2023 19:00:00, _f: undefined, _strict: undefined, _locale: [object Object]
at Function.null (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:324:25)
at null.configFromString (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:2550:19)
at null.configFromInput (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:2993:13)
at null.prepareConfig (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:2976:13)
at null.createFromConfig (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:2943:44)
at null.createLocalOrUTC (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:3037:16)
at null.createLocal (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:3041:16)
at null.hooks (/tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/node_modules/.pnpm/moment@2.29.4/node_modules/moment/moment.js:16:29)
at Object.run (file:///tmp/pdg/dist/code/59d3e0c7a8d2658fdde6497198076fd35d4d3a0a269bcba47bde3dc2101f3ffe/code/actions/format-iso8601-datetime/format-iso8601-datetime.mjs:20:18)
at null.executeComponent (/var/task/launch_worker.js:229:53)

28

please let me know if you need any further info

29

It looks like you’re encountering a deprecation warning related to the moment.js library when trying to format a date. To help you resolve this issue, I’ll need some more information about your code and the specific use case. Can you please provide the relevant code snippet and explain what you’re trying to achieve? This will help me better understand the problem and provide a solution.

30

i’m not sure about the relevant code snippet but I can definitely explain what I am trying to accomplish

31

i am creating a pipedream to connect a google sheet with a notion page database

32

the google sheet is connected to a google form

33

so everytime someone fills out the form, the sheet updates and then notion updates to reflect the new information

34

the notion database is a calendar

35

that displays the date and time

36

of each entry

37

for some reason the formating of the date from google sheets is not aligning with notion

38

so i keep getting an error with the time/date field

39

Btw you need to tag @U05A7KLNALC to have it answer you

40

tysm !!