calender

[abhaysingh]

i have date like july 13, june 13 , how can i make date from date???????

[ashfaq_haseeb]

Hi,

Can you attach few sample lines of data?

regards

ASHFAQ

[its_anandrjs]

Use Date# function for this.

[Anonymous]

set vDateString = 'july 13';

mMonths:

mapping load * inline

[MonthName, MonthNo

january,1

february,2

march,3

april,4

may,5

june,6

july,7

august,8

september,9

october,10

november,11

december,12];

let vMonthString = SubField(vDateString, ' ', 1);

let vYearString = 20 & SubField(vDateString, ' ', 2);

let vDate = MakeDate(vYearString, ApplyMap('mMonths', vMonthString), 1);

[MK_QSL]

Considering july 13 as July 2013.. You can create date as below...

=Date(Date#('july 13','MMMM YY'))

or

=Date(Date#('june 13','MMMM YY'))

Considering july 13 as 13/07/YYYY... You can create date as below with considering Year 2014...

=MakeDate(Year(Today()),Month(Date#('july 13','MMMM DD')),Day(Date#('july 13','MMMM DD')))