Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have date like july 13, june 13 , how can i make date from date???????
Hi,
Can you attach few sample lines of data?
regards
ASHFAQ
Use Date# function for this.
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);
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')))