Hi, Does anyone know of a function that I can use to format a date in a specific manner. Bringing in month names instead of numbers. e.g. From 1/1/2014 I want 'Jan 14' as text In excel I would the text function - TEXT(*date*,"MMM YY") Thanks, Simon
Hi John
I know this is very old post but i was interested in this solution and cant find the formulas you mentioned below? Have they dissapeared?
Cheers
Andrew
John
I can't see any formulas
Chris
Hi John,
Greetings for the day!!
I can't see formulas and screenshots posted by you.
Can you please check once.
Thanks
Pooja
Hi
This is my solution to output "Feb 21" for example:
Date format: First Date of Period = START()
Output for February is 1/2/2021
Time format (month): Month Period = PERIOD(First Date of Period)
Output is "Feb 21".
Regards,
Declan
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…