• Jgk k
  • NEWBIE
  • 10 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
Hello ,
I have a requirement to export data from salesforce using commandline dataloader.I have sucessfully extracted data, but the date fields in my current extract are in format YYYY-MM-DD. My requirement is to get date fields in MM-DD-YYYY format. I have tried using FORMAT() but that doesn't work. 
Can anyone suggest me a way to change the format of date fields?

Thanks in advance. 
  • November 07, 2017
  • Like
  • 0
Hello ,
I have a requirement to export data from salesforce using commandline dataloader.I have sucessfully extracted data, but the date fields in my current extract are in format YYYY-MM-DD. My requirement is to get date fields in MM-DD-YYYY format. I have tried using FORMAT() but that doesn't work. 
Can anyone suggest me a way to change the format of date fields?

Thanks in advance. 
  • November 07, 2017
  • Like
  • 0
Hello,

I am attempting to extract information from a salesforce object using the data loader command line functionality.  I currently have a process-conf and .sdl that execute properly.  However, when I attempt to include Format() in the select statement, I am unsure of how to modify the mapping in the .sdl to bring it into the .csv.  I've tried a couple things that were unsuccessful.

This example works fine:
Select Id, CreatedDate
From Account

This example does not:
Select Id, format(CreatedDate)
From Account