Finance | Project Operations, Human Resources, ...

How to get system date time in stream

(1) Share

Report

Posted on by CU21091228-0

161

Hi Team,

Using below code i am generating the .txt file.

System.IO.Stream        stream;
TextStreamIo            io;
System.IO.StreamReader  reader;
utcDateTime             dateTime;
Str                     fileContent;
 
 dateTime = DateTimeUtil::getSystemDateTime();
     
 io = TextStreamIo::constructForWrite();
 io.writeExp([dateTime]);
 
 stream = io.getStream();
 stream.Position = 0;
 reader = new System.IO.StreamReader(stream);
 filecontent = reader.ReadToEnd();
 File::SendStringAsFileToUser(fileContent, 'MyTextFile.txt');
 
 info(strfmt("%1", dateTime));

In .txt file date time is coming like 2024-09-29T12:37:16Z37001

In info i can see 2024/09/29 13:08:37

Please let me know how to get system date time here.

All responses (5)

Answers (0)

Waed Ayyad 6,360 Super User 2024 Season 2 on at

Like (0)

Report

How to get system date time in stream

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks
Waed Ayyad
RT-23081044-0 4 on at

Like (0)

Report

How to get system date time in stream

To get the system date and time in the desired format, convert the UTC date and time to local time before writing it to the file

System.IO.Stream stream;
TextStreamIo io;
System.IO.StreamReader reader;
utcDateTime utcDateTime;
dateTime localDateTime;
Str fileContent;

utcDateTime = DateTimeUtil::getSystemDateTime();
localDateTime = DateTimeUtil::applyTimeZoneOffset(utcDateTime, DateTimeUtil::getUserPreferredTimeZone());

io = TextStreamIo::constructForWrite();
io.writeExp([localDateTime]);

stream = io.getStream();
stream.Position = 0;
reader = new System.IO.StreamReader(stream);
fileContent = reader.ReadToEnd();
File::SendStringAsFileToUser(fileContent, 'MyTextFile.txt');

info(strfmt("%1", localDateTime));

thanks,

ramjee
Suggested answer

Bill Ngo 370 on at

Like (0)

Report

How to get system date time in stream

Hi CU,

You should use format datetime2Str() for your case then you will get system date time in both Info() and csv file.

System.IO.Stream stream;
TextStreamIo io;
System.IO.StreamReader reader;
//utcDateTime dateTime;
Str fileContent;
Str dateTime = datetime2Str(DateTimeUtil::getSystemDateTime(),DateFlags::FormatAll); //DateTimeUtil::getSystemDateTime();

io = TextStreamIo::constructForWrite();
io.writeExp([dateTime]);

stream = io.getStream();
stream.Position = 0;
reader = new System.IO.StreamReader(stream);
filecontent = reader.ReadToEnd();
File::SendStringAsFileToUser(fileContent, 'MyTextFile.txt');

info(strfmt("Date time is: %1", dateTime));

For more details, you can read a link below:
X++ conversion runtime functions - Finance & Operations | Dynamics 365 | Microsoft Learn
Suggested answer

Martin Dráb 230,370 Most Valuable Professional on at

Like (1)

Report

How to get system date time in stream

If you want a different format of the date and time, convert it to a string by yourself. Obviously, a text file contains text and therefore the date time value must be converted to text. Your current code doesn't specify any format, therefore the default one is used.

You can use either X++ methods, such as DateTimeUtil::toFormattedStr(), or .NET ones, such as System.String::Format().

utcNow() isn't a solution, because it still returns a date and time value, not a string.
Suggested answer

Waed Ayyad 6,360 Super User 2024 Season 2 on at

Like (0)

Report

How to get system date time in stream

Hi,

You can use utcNow() method to get currentDateTime in UTC.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue