Create Date

[#1]

Hi All

I have a Month field containing values Jan to Dec.

How can I create a dummy date field using the Month field I already have?

[Anonymous]

This should work:

=date(date#(2015 & "MonthField" & 01, 'YYYYMMMDD'))

[satishqlik]

Could you attach the sample data.

[PrashantSangle]

Hi,

Use makeDate()

makeDate(2015,MonthField,1)

Regards

[amit_saini · Accepted solution]

Hi,

Like this:

[#6]

Thanks a lot!

[mohammadkhatimi]

MakeDate(num(financialyear),num(wildmatch([month],'Jan*','Feb*','Mar*','Apr*','May*','Jun*','Jul*','Aug*','Sep*','Oct*','Nov*','Dec*')),1)

Try the above logic...