Forum Discussion

Sgarim4's avatar
Sgarim4
New Contributor II
7 years ago
Solved

Date Filter for loading Excel File

I am trying to filter an excel file from a folder based on date to load onto a database. I have successfully managed to get the filter snap to filter out all months other than current month with the ...
  • tarena's avatar
    tarena
    8 months ago

    Thank you. This was pretty close to the problem. If there is an error in a function called in mapValues, a null object is returned as the result of map values. My original error was from adding an or condition that would include keys which couldn't be parsed as dates. This error turned the entire object to null, which was what I observed. 

christwr's avatar
christwr
Contributor III
6 years ago
Copy LinkReport

When using the Date.Parse() function to parse a string, you must also pass a “format” parameter, which specifies how your string is formatted.

parse(dateString, format) - Parse a date string using a custom format. The second argument is a format string using the same syntax as the Java SimpleDateFormat class.

anubhav_nautiya's avatar
anubhav_nautiya
Contributor
6 years ago
Copy LinkReport

Hi Chris
I tried what you mentioned in your comment, however I dont get the expected result, its not able to distinguish between AM and PM and gives same result for both

$dt = 11/12/2019 11:15:00 PM
expected output is 2019-11-12 23:15:00