What is the best/shortest method of converting XML datetime into NAV datetime?

Slawek_Guzek

yyyy-MM-ddThh:mm into NAV datetime please?

Slawek_Guzek

NavDateTime := DotNetDateTime.Parse(DateTimeText);

That's what I've been looking for

nick_robbo

Slawek_Guzek wrote: »

@nick_robbo
Nope. NB: the format you have used is not XML. Try this:

TextDateTime := FORMAT(OriginalTextDateTime, 0, 9)
EVALUATE(DateTime, TextDateTime)

Yes, thanks for that.

I was about to link you to this but I see you have found it...

https://stackoverflow.com/questions/20090297/c-sharp-datetime-conversion-from-yyyy-mm-ddthhmmss-to-dd-mmm-yyyy

Kishorm

The best/shortest method is as follows (doesn’t even require a DotNet variable)...

EVALUATE(NavDateTime,DateTimeText,9);

AK

I'm sure it isn't the shortest or prettiest method, but it works:

GetDateFromText(DateTimeText : Text[30]) DateValue : Date
DateTimeText := COPYSTR(DateTimeText,1,STRPOS(DateTimeText,'T') - 1);

YearText := COPYSTR(DateTimeText,1,STRPOS(DateTimeText,'-') - 1);
DateTimeText := DELSTR(DateTimeText,1,STRLEN(YearText) + 1);

MonthText := COPYSTR(DateTimeText,1,STRPOS(DateTimeText,'-') - 1);
DateTimeText := DELSTR(DateTimeText,1,STRLEN(MonthText) + 1);

DayText := DateTimeText;

EVALUATE(DateValue,DayText + '.' + MonthText + '.' + YearText);

GetTimeFromText(DateTimeText : Text[30]) TimeValue : Time
EVALUATE(TimeValue,COPYSTR(DateTimeText,STRPOS(DateTimeText,'T') + 1,8));

Slawek_Guzek

@AK hmm expected / hoped for a one-liner to be frank... and not in form of combinig all COPYSTR/STRPOS/DELCHR into one call

nick_robbo

Does Evaluate work?

TextDateTime := FORMAT(OriginalTextDateTime)
EVALUATE(DateTime, TextDateTime)

Slawek_Guzek

@nick_robbo
Nope. NB: the format you have used is not XML. Try this:

TextDateTime := FORMAT(OriginalTextDateTime, 0, 9)
EVALUATE(DateTime, TextDateTime)

Slawek_Guzek

NavDateTime := DotNetDateTime.Parse(DateTimeText);

That's what I've been looking for

nick_robbo

Slawek_Guzek wrote: »

@nick_robbo
Nope. NB: the format you have used is not XML. Try this:

TextDateTime := FORMAT(OriginalTextDateTime, 0, 9)
EVALUATE(DateTime, TextDateTime)

Yes, thanks for that.

I was about to link you to this but I see you have found it...

https://stackoverflow.com/questions/20090297/c-sharp-datetime-conversion-from-yyyy-mm-ddthhmmss-to-dd-mmm-yyyy

Kishorm

The best/shortest method is as follows (doesn’t even require a DotNet variable)...

EVALUATE(NavDateTime,DateTimeText,9);

Slawek_Guzek

Kishorm wrote: »

The best/shortest method is as follows (doesn’t even require a DotNet variable)...

EVALUATE(NavDateTime,DateTimeText,9);

Ahh.. Too simple to give it a go

Thanks @Kishorm . THAT was exactly what I was after