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

I have the same question (0)

All responses (13)

Answers (1)

Daniele Ferraretto on at

Like (0)

Report

I think it's possible only by code, or you could use two separate fields and after in your logic merge the information with datetimeutil class

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello Anand

To store date and time in single EDT you have to use utcdatetime EDT.

you can refer to this link for more information

msdn.microsoft.com/.../cc597805.aspx

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report

Hi Daniele Ferraretto,

Now i cant create any new field for time, i have to use existing transdatetime edt only.

Is that possible to get current time and pass it to the Transdatetime EDT field when customer select date by modified field.

Was this reply helpful? Yes No
Suggested answer

Divya Lakshmi 745 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report

Hello Divya,

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

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
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").

Was this reply helpful? Yes No
Divya Lakshmi 745 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

UmesH@ 810 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Divya Lakshmi 745 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

UmesH@ 810 on at

Like (0)

Report

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

Was this reply helpful? Yes No