Cambiar formato de fechas a número

[Valentino_Rossi_46]

Hola alguien me podría ayudar con este tema

Quiero cambiar mis formatos de fecha a sólo númerico de un rango de 1-31 que serían los días del mes( 1, 2, 3, 4).

Para que en el momento que escoja el día 1 por ejemplo se refiera al 1 de febrero del 2018 y del 2019 (seleccionando mes y años por separado )

Fechas

1-02-2018

1-02-2019

Deseo solo seleccionar el 1

saludos

[ajaykakkar93]

hi,

Refer sheet "Cambiar formato de fechas a número" from attached application. 

OR

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

""

[ajaykakkar93]

Script : 

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;

drop Table temp;