How to use date and time in a field?

(0) Share

Report

Posted on by Anand AX

2,172

Hello All,

I want date and time in a single field. For which i used TransDateTime EDT. but when i select, only date value is coming, time is always Zero.

1. How to get date and time? Is there any other EDT..? Or possible only by coding?

2. Also Customer select any date(not only current date), but it should bring current time, Is that possible?

please Clarify me!

*This post is locked for comments

All responses (13)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report
RE: How to use date and time in a field?

Thank you,

finally,

DateTimeUtil::utcNow()
Martin Dráb 230,198 Most Valuable Professional on at

Like (0)

Report

RE: How to use date and time in a field?

Could you please mark the verified answers? This thread is still not displayed as resolved...
Divya Lakshmi 745 on at

Like (0)

Report

RE: How to use date and time in a field?

Dear team ,

Sorry for my last reply ..it was my misunderstanding..Thank u for explanations..I'm clear now..and got some info....

Thanks & Regards,

Divya lakshmi.J
Suggested answer

UmesH@ 810 on at

Like (0)

Report

RE: How to use date and time in a field?

you can use built in funtion as below:

1)date
static void date2StrExample(Args _arg)
{
    date d = today();
    str s;
    ;
    s = date2Str(d, 123, 2, -1, 2, -1, 2);
    print "Today's date is " + s;
    pause;
}
2) time
static void timeNowExample(Args _arg)
{
    int i;
    ;
    i = timeNow();
    print "The number of seconds since midnight is " + int2Str(i);
    pause;
}

3) use Time to str function to convert time in second form your desire format.
// Returns the text string 05:01:38.
time2Str(18098,1,1);
// Returns the text string 05:01:38 am.
time2Str(18098,1,2);
// Returns the text string 05 01 39.
time2Str(18099,3,1);
// Returns the text string 05/01/39 am.
time2Str(18099,5,2);

4) finally using 1,2 & 3 you can get date&time.
no
Divya Lakshmi 745 on at

Like (0)

Report

RE: How to use date and time in a field?

Hi Jignesh ,

I have replicated what you have replied. But its reflecting the same issue.

Please find screenshot. I Want to know any other settings to be checked in preferred time zone.

Regards,

Divya Lakshmi.J
Suggested answer

UmesH@ 810 on at

Like (0)

Report
RE: How to use date and time in a field?

insert in table Date,Time and Datetime

if Date inserted then Check EDT (extendedDataType) Property is basedate.

if Time inserted then Check EDT (extendedDataType) Property is Timeofday.

if DateTime inserted then Check EDT (extendedDataType) Property is UTCTimestamp.

if you have to Seperate Date then Use

Here DateP is BaseDate;

date2str(dateP,123,DateDay::Digits2,DateSeparator::Hyphen,DateMonth::Digits2,
DateSeparator::Hyphen,DateYear::Digits4);

Or Else You Can Dynamically Inserted Date and Time in Your table.

Thanks.
Divya Lakshmi 745 on at

Like (0)

Report

RE: How to use date and time in a field?

Hi,

Anand is right.He mean to say that if a new field created of type UTCDATETIME and if I create a record(ie.If I select todays date by 10.50AM )the record shows only the date but with the time 12.00AM...and not as 10.50 AM

please find attachment for the demo of his scenario.

@Anand :correct me if i'm wrong
Verified answer

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

Like (1)

Report
RE: How to use date and time in a field?

This is how you can assign the current time:

yourTable.YourField = DateTimeUtil::utcNow();

Note that I don't understand the latter part of your requirement ("to get current time and pass it to the Transdatetime EDT field when customer select date by modified field").
Anand AX 2,172 on at

Like (0)

Report

RE: How to use date and time in a field?

Hello Divya,

I used already as you said, but whatever date i select(including current date), the date only coming, time is not..!
Suggested answer

Divya Lakshmi 745 on at

Like (0)

Report

RE: How to use date and time in a field?

Hi,

Right click on fields node and create a field of type UTCDateTime.This will store date and time simultaneously. If u select today date, then the field will store the today date and current time.

Regards,

Divya Lakshmi.J