HomeForum
Welcome, Guest

GetSystemDate in a calculation
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: GetSystemDate in a calculation

GetSystemDate in a calculation 1 year, 9 months ago #934

  • Dave
  • OFFLINE
  • Junior Boarder
  • Posts: 20
  • Karma: 0
Hello,

I’m trying to use GetSystemDate in a calculation (see below). I’m not getting a value in my destination. Is there a problem with my syntax?
Advanced ETL Processor Pro version 4.2.0.8.

Dave

Re:GetSystemDate in a calculation 1 year, 9 months ago #935

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
David

List of functions you can use in calculation is slightly different from the functions you can use in file names mask etc

This one works

begin
Result:=FormatDateTime('DDMMYYYY',now);
end;

Or you can use current date transformation function

Peter
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

"DBSL software makes it much easier for us to enable new customers for automatic order processing. This alone sets us apart from the competition."

M. Clock, Director,
Clock Logistics

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top