How to remove Time part in FM MODEL from date/time QueryItem .. please

[bujji]

Hello All,

i am using sql server 2005, here in accounts table,  i am having opendate column which is having DateTime as datatype now when i testing in FM Model (QuerySubject Definition--> Test Tab) it shows Data with Time ,

in order to remove time part from the column in FM model, i did as below, but still it shows Data & Time


dateadd({dd},0, datediff({dd},0, [DataBaseSubjects].[Accounts].[OpenDate] ))



could any one help me please..
how can i make it to show only date no time at all

Thanks & Regards
asin

[John_Russell]

Howdy!

You could always make this change in the FWM, by applying the pattern "MM/dd/yyyy" to the Datetime field.  This will do the trick!

I have attached a screenshot for further reference.

John

[TEVAMANA]

Hi,

To remove time from your datetime you can use this SQL Server 2005 function: CAST(DATETIME AS DATE)

Regards