Finance | Project Operations, Human Resources, ...

How to get system date time in stream

(1) Share

Report

Posted on by CU21091228-0

230

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.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Bill Ngo 372 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RT-23081044-0 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

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

Thanks
Waed Ayyad

Was this reply helpful? Yes No