Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How do i create a Date Field if i have Data for Month and Year on an Applymap Function?
e.g June 2015
Thanks.
You can use MakeDate() function
MakeDate(Year, Month, Day) as Date and if you don't have day you can use any day
MakeDate(Year, Month, 1) as Date
Hi Sunny,
i dont want to include the Day as it will confuse my model that has Days.
do i have to take out only day?
Thanks.
You need to put that there to create a date, but after that you can format it anyway you want. For instance:
Date(MakeDate(Year, Month, 1), 'MMM-YYYY') as Date or my personal favorite
MonthName(MakeDate(Year, Month, 1)) as MonthYear
Without Day, you cann't make any date field.
You can try this also:
Date#(Year & '-' & Month, 'YYYY-MMM') as Date
Hi there,
I have 3 data tables and want a variable at the top of my worksheet that allows the user to select Month and have the 3 below tables perform their formulations as per the month selected in the variable input.
Could you please help me create a variable where the end user can select a month and have the below datasets reflect corresponding data to the selected month?
Currently my variable is named 'vAsOfPricingMonthValue' and the expression is 'Month' .
Thank you in advance!