Convert Date to DateTime

(0) Share

Report

Posted on by Toffsam

985

Good day House. Please I am facing a challenge now. I have to assign a "Date" Value to a "DateTime" variable. How do I convert the "Date" to a "DateTime"?

Thanks for your help.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

You can do like this:

YourDateTime := CREATEDATETIME(YourDate,0T);

Was this reply helpful? Yes No
Toffsam 985 on at

Like (0)

Report

Hi Demiliani,

thanks for your reply. Yes I tried that before but still could not achieve my aim . What I really want to achieve is setfilter on a DateTime field in a table, now the value to setfilter with is a Date value and am getting error: Conversion is not possible Date:= DateTime.

This is my code:

varEndDate := CREATEDATETIME(EndDate,0T);

SETFILTER(LastDayMonth,'<=%1',CALCDATE('CM', varEndDate));

Note: "LastDayMonth" is a DateTime field from the record(Table) which holds last day of

month for a date.

"EndDate" is a Date value coming from Request page

"varEndDate" is the DateTime variable i am assigning my converted date value so I

can setfilter on my record.

I get the error on the SETFILTER(LastDayMonth,'<=%1',CALCDATE('CM', varEndDate)); lin e that "Conversion is not possible because 1 of the operators contain an invalid type. Date:= DateTime."

Please how can I achieve this filter.

Thanks again.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

I think that the problem is in the CALCDATE function. The second parameter must be a Date value.

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

Hi Toffsam,

Totally agree with Stefano:

"YourDateTime := CREATEDATETIME(YourDate,0T);"

Another way is:

IF EVALUATE(YourDateTime, FORMAT(YourDate)) THEN;

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Toffsam,

Change a little bit your code:

varEndDate := CREATEDATETIME(CALCDATE('CM', EndDate), 0T);

SETFILTER(LastDayMonth, '<=%1', varEndDate);

Was this reply helpful? Yes No
Toffsam 985 on at

Like (0)

Report

Thanks Khoa. It works.

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

You are welcome, have a nice day!

Was this reply helpful? Yes No
Toffsam 985 on at

Like (0)

Report

Hi Khoa,

I sent you an email on this Remote/Part-Time Position.

Thanks.

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

Hi Toffsam,

I replied your email and also added your Skype.

I'm looking for a Remote or Part-Time Position. I have 6 hours/day available and would like to provide it to any company looking for NAV experience person.

Was this reply helpful? Yes No
Suggested answer

Nadeem Altaf 10 on at

Like (0)

Report

DateTime := CREATEDATETIME(Date, Time)

Was this reply helpful? Yes No

Community site session details

Convert Date to DateTime

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates

Community site session details

Convert Date to DateTime

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates