Cannot format date correctly to YYYY-MM-DD
Hi there, I’ve looked at other articles addressing this but non has helped me so far. Im looking to format a date in the DD/MM/YYYY to YYYY-MM-DD. The date will always be populated. I’ve tried the following expressions but they wont process correctly Date.parse($original[‘Due Date’], “yyyy MM dd”) LocalDate.parse($original[‘Due Date’],“yyyy/MM/dd”) If I use the above expression and if the date is 06/04/2021, the output date becomes 0006-04-18. It’s inexplicable.
Dates to BigQuery problem
I’m trying to export some dates into BigQuery, but even though the preview of the data that is being sent to BigQuery is correct, when I check my table in BigQuery it always shows as null. Any idea on how to solve this? My data is parsed this way: Date.parse($ACCT_STATUS_DATE.Date,“yyyy-MM-dd”)
