Input3
2019-01-31
S550730
1997-05-24
S640106
H150224
1999-03-21
1982-12-03
2019-01-09
R011101
1926-02-25
M450522
Input
Simple
Contains
Field1
True
fixed
2020-11-01 14:51:04
0
-
2020-11-01 14:51:04
2020-11-01 14:51:04
Contains([Field1],"-")
W
W Output
Date
D
D Output
W to D
Era = left([Field1],1)
Year = TOnUMBER(substring([Field1],1,2))
Month = TOnUMBER...
YearEra = datetimeyear([Start_DT])
Year = [Year]+ [YearEra]
Date = tostring([Yea...
Cleanup dates on Era
M
Meiji
10-23-1868
07-30-1912
T
Taisho
07-31-1912
12-25-1926
S
Showa
12-26-1926
01-07-1989
H
Heisei
01-08-1989
04-30-2019
R
Reiwa
05-01-2019
01-01-2050
Era Definitions
Era Definitions
Start
English
MM-dd-yyyy
Start_DT
Convert Start From:
MM-dd-yyyy
End
English
MM-dd-yyyy
End_DT
Convert End From:
MM-dd-yyyy
D to W
Error
[Field1] >= [Start_DT] AND
[Field1] <= [End_DT]
Custom
[Field1] >= [Start_DT] AND
[Field1] <= [End_DT]
YearDiff = DateTimeDiff([Field1],[Start_DT],'year')
Wareki = [Era] + PadLeft(tos...
Horizontal
Question
Macro Input (3)
Question
Macro Output (6)
Question
Macro Output (23)
DateMacro
Tab
Questions
Tab (5)
MacroInput
Macro Input (3)
MacroOutput
Macro Output (6)
Macro Output (6)
LabelGroup
LabelGroup (10)
LabelGroup (10)
MacroOutput
Macro Output (6)
Macro Output (23)
Macro