hi guys i have a problem with a date that is imported into appsheet via an external service.
In the table, the column containing the date is of type TEXT,
The date has this format Mon, May 01 2023 - 10:00 AM I have to extrapolate only the date in the format 01/05/2023.
do you have any advice?
Solved! Go to Solution.
Please try
DATE(CONCATENATE(
MID([Date Column], 10 , 2),"/",
SWITCH(MID([Date Column], 6 , 3), "Jan", "01", "Feb", "02", "Mar", "03", "Apr" , "04", "May", "05", "Jun", "06", "Jul", "07" , "Aug", "08", "Sep", "09", "Oct" , "10", "Nov", "11", "Dec", "12" ,"00"),"/",
MID([Date Column] , 13, 4)
)
)
The expression assumes the months names are in 3 characters long format . If those are actual month names in long format , then the solution will not work.
[Date Column] is the column containing the date in the format "Mon, May 01 2023 - 10:00 AM"
Please try
DATE(CONCATENATE(
MID([Date Column], 10 , 2),"/",
SWITCH(MID([Date Column], 6 , 3), "Jan", "01", "Feb", "02", "Mar", "03", "Apr" , "04", "May", "05", "Jun", "06", "Jul", "07" , "Aug", "08", "Sep", "09", "Oct" , "10", "Nov", "11", "Dec", "12" ,"00"),"/",
MID([Date Column] , 13, 4)
)
)
The expression assumes the months names are in 3 characters long format . If those are actual month names in long format , then the solution will not work.
[Date Column] is the column containing the date in the format "Mon, May 01 2023 - 10:00 AM"
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |