Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
1 year ago
Solved

DateToText Swaps Month and Day Python Microsoft.OleDb.Date

Hi all, Using PBID April 2025. I'm using a Python Script to export a dataframe to csv file All of the date columns are returning Microsoft.OleDb.Date So I need to convert all date columns to te...
  • tecumseh's avatar
    1 year ago

    Guess I need to specify the format string

    Date.ToText([CAMPAIGN_START_DATE], [Format="MM/dd/yyyy"])

    A little odd that Month must be uppercase MM then day and year are lowercase.