How to set Date Format like this ddMMYYYY

date format  date month In the load script, you use the date() function to convert the numerical date into a date format Because you do not provide a specified format as The ISO standard takes a general-to-specific approach for its date formats: The year comes first, followed by the month and then by the day of the month, with

In America, the date is formally written in monthdayyear form Thus, “January 1, 2011” is widely considered to be correct In formal usage, it is not Date format abbreviations are Y or J for the year, M for the month and D or T for the day The specification of special terms is possible in date

The object enables language-sensitive date and time formatting Try it  The Format DateTime String function calculates the date and time and formats the output string according to the following format codes