Forum Discussion

amit_saroha's avatar
amit_saroha
New Contributor III
4 years ago

Incorrect date format

Hi, My requirement is to pass the date as a string “YYYY/MM/DD HH:MI:SS” as a parameter to Oracle procedure snap. I amssusing the expression - Date.now().toLocaleDateString({“format”:“yyyy/MM/dd HH...
pranjbhatt's avatar
pranjbhatt
New Contributor III
11 months ago
Copy LinkReport

Hi, 

Following is the sample data. I need to have latest last_date values for each of the source (source_code) and each of the target table.  Note that date is in dd-MM-yyyy format.

 

INPUT     
TARGET TABLESOURCE CODELAST DATE RUN DATELOAD STATUS TYPE
DIM_CLIENTconcentrix03-09-202403-09-2024NowPositive
DIM_CLIENTconcentrix30-08-202403-09-2024NowPositive
DIM_CLIENTenvizi01-09-202403-09-2024NowPositive
DIM_CLIENTenvizi27-08-202403-09-2024NowPositive
USERenvizi28-08-202403-09-2024NowPositive
USERconcentrix02-09-202403-09-2024NowPositive
USERconcentrix29-08-202403-09-2024NowPositive
USER envizi27-08-202403-09-2024NowPositive

 

OUTPUT     
TARGET TABLESOURCE CODELAST DATE RUN DATELOAD STATUS TYPE
DIM_CLIENTconcentrix03-09-202403-09-2024NowPositive
DIM_CLIENTenvizi01-09-202403-09-2024NowPositive
USERenvizi28-08-202403-09-2024NowPositive
USERconcentrix02-09-202403-09-2024NowPositive
  • amit_saroha's avatar
    amit_saroha
    New Contributor III
    4 years ago
    Copy LinkReport

    Actually, it’s passed from parameter only, please see below and I couldn’t understand what do you mean by _p_processing_date and where I have to pass it?

    • dmiller's avatar
      dmiller
      Former Employee
      4 years ago
      Copy LinkReport

      what do you mean by _p_processing_date

      In SnapLogic terminology:

      • when you reference a field, it is prefaced with the dollar sign ($)
      • when you reference a parameter (which is defined in the pipeline properties), it is prefaced with the underscore (_). Parameters are strings.

      So if the p_processing_date was a parameter, you would use _p_processing_date.
      In this case, you are mapping a date to a field.