Change date format

[#1]

Hi Guys

How can u separate time in a date field table and also i need to separate months and year individual

Example : Now It's like 01/01/2014 , I want to change to Jan/2014.

[Anonymous]

Date(YourDateTime) will return date

Time(YourDateTime) will return time

Date(Today(),'MMM/YYYY') will return Month\Year format

[MichaelTerenzi]

Now It's like 01/01/2014 , I want to change to Jan/2014.  -----

For the above request, something like this will work for the date formatting:

MMM/YYYY h:mm:ss[.fff] TT

[#4]

format pattern: mmm/yyyy

[maxgro]

floor(datatimefield) is your date part, example 41904

date(floor(datatimefield)) is your date part formatted as a date

frac(datatimefield) is the time part from 0 to 1

time(frac(datatimefield)) is the time part formatted

[#6]

Hi Prakash,

Just try like the below code

=Date( Makedate( right(fieldvalue,4), Mid(fieldvalue,4,2) ) , 'MMM/YYYY')

hope it helps!!

Kiru

[#7]

Hi guys,

thanks u for ur support

[#8]

hi

try this

DATE(date#(left(Date,19),'DD/MM/YYYY hh:mm:ss'),'MMM/YYYY') AS NEWDATE