Refer sheet "Cambiar formato de fechas a número" from attached application.
Consulte la hoja "Cambiar formato de fechas a número" De la solicitud adjunta.
Hello, someone could help me with this topic I want to change my date formats to only numeric of a range of 1-31 which would be the days of the month (1, 2, 3, 4). So that at the time you choose day 1, for example, refer to February 1, 2018 and 2019 (selecting month and years separately) Dates 02-01-2018 02-01-2019 I just want to select 1
temp: load date(MakeDate(2017,1,1) + RowNo(),'DD-MM-YYYY ') as date AutoGenerate today() - date(MakeDate(2017,1,1) + RowNo(),'DD-MM-YYYY ');
Cal: load date, day(date) as DateDay, month(date) as month, year(date) as year, num(month(date)) as monthNo, ceil(month(date)/3) as quarter, 'Q'&ceil(month(date)/3) as quarterName, week(date) as week, WeekDay(date) as weekday, WeekName(date) as weekName, If(Month(date)<=3,Month(date)+9,Month(date)-3) as FiscalMonth, If(Month(date)>3,Year(date)+1,Year(date)) as FiscalYear Resident temp;