How to get date in a field X++

(0) Share

Report

Posted on by Farwa Khizar

174

Hi all,

I have created a field fromDate (FieldDate type) in a table and extended data type for this field is "TransDate", Now i want to store only date in it but its storing date along time like this 9/9/2015 12:00:00 AM. it always store time 12:00:00 AM whatever value is passed through parameter. what should i do in order to store only date in it?

Note: i am passing fromDate through parameter created in contract class and storing its value in table datefield.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Farwa,

The SQL server is working internally with the time as it only knows date/time fields. When using TransDate as EDT, the business logic within the applicationwill use the date part only.

It would be interested to know where you see the time part, like Sukrut mentioned also.

Was this reply helpful? Yes No
Farwa Khizar 174 on at

Like (0)

Report

Actually I am showing it in report, i have to fetch data on the basis of fromDate and toDate parameters, but this date format is not working if i compare it with systems table date. (system table date is also extended to TransDate). here is the screenshots of report and properties of FromDate field

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

It happens in SSRS, you need to format your textboxs, setting values like format(Fields!FromDate.value,"MM/dd/yyyy") or using the textbox properties using date for type data

Was this reply helpful? Yes No