Date

[smilingjohn]

I have the date format like this

8/9/2015  12:00:00AM

I want to have only Date like 8/9/2015

How to achieve this at the sript level.

PLease find the attachment below ,with sample Excel file

Thanks in advance

[Anonymous]

Date(Date#((DateField, 8), 'M/D/YYYY'), 'M/D/YYYY') as Date in this expression Datefield later to give the your format than it is working

[HirisH_V7]

Hi,

Like this ways,

Date(Floor(OrderDate)) as OrderDate,
  OrderDate,
  Subfield(OrderDate,' ',1) as Date,
  Date(Timestamp(OrderDate,'M/D/YYYY  hh:mm:ssTT'),'M/D/YYYY') as Time,
  Trim(Mid(OrderDate,1,10)) as Datee

Here your calendar is working fine,

PFA,

HTH,

Hirish